/*
 Navicat Premium Data Transfer

 Source Server         : 140.143.94.155_zbcx_oa
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 140.143.94.155:3306
 Source Schema         : shop

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 01/06/2020 10:05:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cate
-- ----------------------------
DROP TABLE IF EXISTS `cate`;
CREATE TABLE `cate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `layer` int(11) NOT NULL,
  `glid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `picture` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cate
-- ----------------------------
BEGIN;
INSERT INTO `cate` VALUES (2, 3, 0, '男装女装', '', 1);
INSERT INTO `cate` VALUES (3, 4, 0, '母婴用品', '', 1);
INSERT INTO `cate` VALUES (4, 25, 3, '男装', '', 1);
INSERT INTO `cate` VALUES (5, 26, 3, '女装', '', 1);
INSERT INTO `cate` VALUES (6, 27, 25, '男士T恤', '/static/temp/cate13.jpg', 1);
INSERT INTO `cate` VALUES (7, 28, 25, '男士外套', '/static/temp/cate14.jpg', 1);
INSERT INTO `cate` VALUES (8, 29, 26, '裙装', '/static/temp/cate15.jpg', 1);
INSERT INTO `cate` VALUES (9, 30, 26, 'T恤', '/static/temp/cate16.jpg', 1);
INSERT INTO `cate` VALUES (10, 33, 4, '奶粉', '', 1);
INSERT INTO `cate` VALUES (11, 34, 4, '营养辅食', '', 1);
INSERT INTO `cate` VALUES (12, 35, 4, '童装', '', 1);
INSERT INTO `cate` VALUES (13, 39, 4, '喂养用品', '', 1);
INSERT INTO `cate` VALUES (14, 36, 33, '有机奶粉', '/static/temp/cate17.jpg', 1);
INSERT INTO `cate` VALUES (15, 37, 34, '果泥/果汁', '/static/temp/cate18.jpg', 1);
INSERT INTO `cate` VALUES (16, 39, 34, '面条/粥', '/static/temp/cate20.jpg', 1);
INSERT INTO `cate` VALUES (17, 42, 35, '婴童衣橱', '/static/temp/cate19.jpg', 1);
INSERT INTO `cate` VALUES (18, 43, 39, '吸奶器', '/static/temp/cate21.jpg', 1);
INSERT INTO `cate` VALUES (19, 44, 39, '儿童餐具', '/static/temp/cate22.jpg', 1);
INSERT INTO `cate` VALUES (20, 45, 39, '牙胶安抚', '/static/temp/cate23.jpg', 1);
INSERT INTO `cate` VALUES (21, 0, 0, '环球美食', '/static/temp/c3.png', 0);
INSERT INTO `cate` VALUES (22, 0, 0, '个护美妆', '/static/temp/c5.png', 0);
INSERT INTO `cate` VALUES (23, 0, 0, '营养保健', '/static/temp/c6.png', 0);
INSERT INTO `cate` VALUES (24, 0, 0, '家居厨卫', '/static/temp/c7.png', 0);
INSERT INTO `cate` VALUES (25, 0, 0, '速食生鲜', '/static/temp/c8.png', 0);
COMMIT;

-- ----------------------------
-- Table structure for entity
-- ----------------------------
DROP TABLE IF EXISTS `entity`;
CREATE TABLE `entity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `namee` varchar(32) DEFAULT NULL,
  `namec` varchar(32) NOT NULL,
  `type` decimal(5,0) NOT NULL,
  `major` decimal(5,0) NOT NULL,
  `minor` decimal(5,0) NOT NULL,
  `domain` decimal(5,0) NOT NULL,
  `tabgrp` varchar(64) DEFAULT NULL,
  `tabatt` varchar(64) DEFAULT NULL,
  `glmaj` decimal(5,0) NOT NULL,
  `glmin` decimal(5,0) NOT NULL,
  `log` decimal(1,0) NOT NULL DEFAULT '0',
  `form` varchar(64) DEFAULT NULL,
  `func` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entity_name` (`name`),
  UNIQUE KEY `entity_majmin` (`major`,`minor`)
) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of entity
-- ----------------------------
BEGIN;
INSERT INTO `entity` VALUES (9, 'sysdef', 'System', '子系统', 1, 99, 1, 99, NULL, 'sysdef', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (10, 'syscfg', 'System Config', '系统配置', 1, 99, 2, 99, NULL, 'syscfg', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (11, 'syscache', 'System Cache', '系统缓存', 1, 99, 3, 99, NULL, 'syscache', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (12, 'entity', 'Entitiy', '实体', 1, 99, 4, 99, NULL, 'entity', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (13, 'fld', 'Field', '字段', 1, 99, 5, 99, NULL, 'fld', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (14, 'fldvalue', 'Field Value', '字段值', 1, 99, 6, 99, NULL, 'fldvalue', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (16, 'plugin', 'Plugin', '插件', 1, 99, 8, 99, NULL, 'plugin', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (17, 'funcgrp', 'Function Group', '功能组', 1, 99, 9, 99, NULL, 'funcgrp', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (18, 'func', 'Function', '功能', 1, 99, 10, 99, NULL, 'func', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (19, 'face', 'Face', '皮肤', 1, 99, 11, 99, NULL, 'face', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (20, 'organ', 'Organ', '组织机构', 1, 99, 12, 99, NULL, 'organ', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (21, 'user1', 'User', '用户', 1, 99, 13, 99, NULL, 'user1', 0, 0, 0, 'static/forms/user1.html', NULL);
INSERT INTO `entity` VALUES (22, 'sysuser', 'System User', '系统用户', 1, 99, 14, 99, NULL, 'sysuser', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (23, 'sysrole', 'Role', '角色', 1, 99, 15, 99, NULL, 'sysrole', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (24, 'userrole', 'User Role', '用户角色', 1, 99, 16, 99, NULL, 'userrole', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (25, 'userdep', 'User Department', '用户部门', 1, 99, 17, 99, NULL, 'userdep', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (26, 'sysroleobj', 'sysroleobj', '角色对象表', 1, 99, 18, 99, NULL, 'sysroleobj', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (27, 'terrain', 'Terrain Layers', '地形图层', 1, 99, 30, 99, NULL, 'terrain', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (28, 'wms', 'Wms Layers', 'WMS图层', 1, 99, 31, 99, NULL, 'wms', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (29, 'wfs', 'Mfs Layers', 'WFS图层', 1, 99, 32, 99, NULL, 'wfs', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (30, 'vector', 'Vector Layers', '矢量图层', 1, 99, 33, 99, NULL, 'vector', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (31, 'viewport', 'Viewport', '视图', 1, 99, 34, 99, NULL, 'viewport', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (32, 'region', 'Region', '区域', 1, 99, 35, 99, NULL, 'region', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (33, 'layer', 'Layer', '图层', 1, 99, 36, 99, NULL, 'layer', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (34, 'mapara', 'Map Parameter', '制图参数', 1, 99, 37, 99, NULL, 'mapara', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (35, 'loginlog', 'Login LOG', '登录日志', 1, 99, 38, 99, NULL, 'loginlog', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (36, 'operlog', 'Operation LOG', '操作日志', 1, 99, 39, 99, NULL, 'operlog', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (37, 'sysgroup', 'Group', '组', 1, 99, 40, 99, NULL, 'sysgroup', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (38, 'usergroup', 'User Group', '用户组', 1, 99, 41, 99, NULL, 'usergroup', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (39, 'sysds', 'Data Source', '数据源', 1, 99, 42, 99, NULL, 'sysds', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (42, 'media', 'media', '附件', 1, 99, 45, 99, NULL, 'media', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (301, 'shop', 'shop', '商品表', 1, 97, 2, 99, NULL, 'shop', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (305, 'evaluate', 'evaluate', '商品评价', 1, 97, 3, 99, NULL, 'evaluate', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (306, 'orderinfo', 'orderinfo', '商品订单', 1, 97, 4, 99, NULL, 'orderinfo', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (307, 'seckill', 'seckill', '秒杀表', 1, 97, 5, 99, NULL, 'seckill', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (308, 'cate', 'cate', '分类表', 1, 97, 6, 99, NULL, 'cate', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (309, 'shopcart', 'shopcart', '购物车表', 1, 97, 7, 99, NULL, 'shopcart', 0, 0, 0, NULL, NULL);
INSERT INTO `entity` VALUES (310, 'history', 'history', '浏览历史', 1, 97, 8, 99, NULL, 'history', 0, 0, 0, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for evaluate
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) NOT NULL,
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `shopid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `lx` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of evaluate
-- ----------------------------
BEGIN;
INSERT INTO `evaluate` VALUES (1, '商品收到了，79元两件，质量不错，试了一下有点瘦，但是加个外罩很漂亮，我很喜欢', '2020-03-07 04:00:00', 1, 1, '张三', 'http://img3.imgtn.bdimg.com/it/u=1150341365,1327279810&fm=26&gp=0.jpg', 'M 红色');
INSERT INTO `evaluate` VALUES (2, '商品收到了，79元两件，质量不错，试了一下有点瘦，但是加个外罩很漂亮，我很喜欢', '2020-03-07 01:00:00', 1, 1, '张三', 'http://img3.imgtn.bdimg.com/it/u=1150341365,1327279810&fm=26&gp=0.jpg', 'M 红色');
COMMIT;

-- ----------------------------
-- Table structure for fld
-- ----------------------------
DROP TABLE IF EXISTS `fld`;
CREATE TABLE `fld` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sys` varchar(16) NOT NULL,
  `tabname` varchar(32) NOT NULL,
  `colname` varchar(32) NOT NULL,
  `namec` varchar(64) NOT NULL,
  `namee` varchar(64) DEFAULT NULL,
  `isnum` decimal(1,0) NOT NULL,
  `disporder` decimal(2,0) NOT NULL,
  `disptype` decimal(2,0) NOT NULL,
  `newedit` decimal(1,0) NOT NULL,
  `editable` decimal(1,0) NOT NULL,
  `nullable` decimal(1,0) NOT NULL,
  `disprows` decimal(2,0) NOT NULL,
  `minval` varchar(16) DEFAULT NULL,
  `maxval` varchar(16) DEFAULT NULL,
  `defval` varchar(32) DEFAULT NULL,
  `minlen` decimal(4,0) NOT NULL DEFAULT '0',
  `maxlen` decimal(4,0) NOT NULL DEFAULT '0',
  `groupe` varchar(64) DEFAULT NULL,
  `groupc` varchar(64) DEFAULT NULL,
  `qrylevel` decimal(1,0) NOT NULL DEFAULT '1',
  `bzfld` decimal(1,0) NOT NULL DEFAULT '0',
  `ismcard` decimal(1,0) NOT NULL DEFAULT '0',
  `pattern` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fld_tabcol` (`tabname`,`colname`),
  KEY `fld_sys` (`sys`)
) ENGINE=InnoDB AUTO_INCREMENT=8089 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of fld
-- ----------------------------
BEGIN;
INSERT INTO `fld` VALUES (241, '99', 'syscfg', 'keyno', '键值', 'Name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (242, '99', 'syscfg', 'namec', '中文名称', 'Name(Chinese)', 0, 2, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (243, '99', 'syscfg', 'namee', '英文名称', 'Name(English)', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (244, '99', 'syscfg', 'value', '键值', 'Value', 0, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (245, '99', 'syscfg', 'memo', '备注', 'Memo', 0, 5, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (246, '99', 'entity', 'name', '实体名', 'Name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (247, '99', 'entity', 'namec', '中文名', 'Name(Chinese)', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (248, '99', 'entity', 'namee', '英文名', 'Name(English)', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (249, '99', 'entity', 'type', '类型', 'Type', 1, 4, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (250, '99', 'entity', 'major', '主类型', 'Major', 1, 5, 1, 1, 1, 0, 1, '1', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (251, '99', 'entity', 'minor', '子类型', 'Minor', 1, 6, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (252, '99', 'entity', 'domain', '域', 'Domain', 1, 7, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (253, '99', 'entity', 'tabgrp', '图形表名', 'Graph Table', 0, 8, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (254, '99', 'entity', 'tabatt', '属性表名', 'Att Table', 0, 9, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (255, '99', 'entity', 'glmaj', '关联主类型', 'Major', 1, 10, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (256, '99', 'entity', 'glmin', '关联子类型', 'Minor', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (257, '99', 'entity', 'log', '记录日志', 'Need Log', 1, 12, 2, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (258, '99', 'entity', 'form', '属性模板', 'Form Template', 0, 13, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (259, '99', 'fld', 'sys', '系统号', 'System No', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (260, '99', 'fld', 'tabname', '数据表名', 'Table Name', 0, 2, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (261, '99', 'fld', 'colname', '列名', 'Column Name', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (262, '99', 'fld', 'namec', '中文名', 'Name(Chinese)', 0, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (263, '99', 'fld', 'namee', '英文名', 'Name(English)', 0, 5, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (264, '99', 'fld', 'isnum', '是否数值型', 'Is Number', 1, 6, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (265, '99', 'fld', 'disporder', '排列位置', 'Display Order', 1, 7, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (266, '99', 'fld', 'disptype', '显示类型', 'Display Type', 1, 8, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (267, '99', 'fld', 'newedit', '新输入可编辑', 'New Editable', 1, 9, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (268, '99', 'fld', 'editable', '是否可编辑', 'Editable', 1, 10, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (269, '99', 'fld', 'nullable', '是否可空', 'Nullable', 1, 11, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (270, '99', 'fld', 'disprows', '显示行数', 'Display Row(s)', 1, 12, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (271, '99', 'fld', 'minval', '最小值', 'Minimun Value', 0, 13, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (272, '99', 'fld', 'maxval', '最大值', 'Maximun Value', 0, 14, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (273, '99', 'fld', 'defval', '默认值', 'Default Value', 0, 15, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (274, '99', 'fld', 'minlen', '最小长', 'Minimun Length', 1, 16, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (275, '99', 'fld', 'maxlen', '最大长', 'Maximun Length', 1, 17, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (276, '99', 'fld', 'groupe', '组名英文', 'Group(English)', 0, 18, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (277, '99', 'fld', 'groupc', '组名中文', 'Group(Chinese)', 0, 19, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (278, '99', 'fld', 'qrylevel', '查询级别', 'Query Level', 1, 20, 2, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (279, '99', 'fld', 'bzfld', '标注字段', 'Lable Fld', 1, 21, 2, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (280, '99', 'fld', 'ismcard', '卡片显示字段', 'Card Fld', 1, 22, 2, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (281, '99', 'fldvalue', 'sys', '系统号', 'System No', 0, 1, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (282, '99', 'fldvalue', 'tabname', '数据表名', 'Table Name', 0, 2, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (283, '99', 'fldvalue', 'colname', '列名', 'Column Name', 0, 3, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (284, '99', 'fldvalue', 'disporder', '排列位置', 'Display Order', 1, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (285, '99', 'fldvalue', 'dbvalue', '对应值', 'Database Value', 0, 5, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (286, '99', 'fldvalue', 'dispc', '显示中文', 'Display(Chinese)', 0, 6, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (287, '99', 'fldvalue', 'dispe', '显示英文', 'Display(English)', 0, 7, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (504, '99', 'fldcfg', 'sys', '系统号', 'Sys no', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (505, '99', 'fldcfg', 'plugin', '插件', 'Plugin', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (506, '99', 'fldcfg', 'func', '功能', 'Function', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (507, '99', 'fldcfg', 'disporder', '显示顺序', 'Disp order', 1, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (508, '99', 'fldcfg', 'name', '名称', 'Name', 0, 5, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (509, '99', 'fldcfg', 'namee', '名称(英文)', 'Name(en)', 0, 6, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (510, '99', 'fldcfg', 'namec', '名称(中文)', 'Name(ch)', 0, 7, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (511, '99', 'fldcfg', 'colname', '列名', 'Column name', 0, 8, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (512, '99', 'sysds', 'name', '名称', 'Name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (513, '99', 'sysds', 'ds', '数据源', 'Data Source', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (514, '99', 'sysds', 'dbo', '拥有者', 'Owner', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (515, '99', 'sysds', 'type', '类型', 'Type', 0, 4, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (540, '0', 'urlmap', 'name', '名称', 'Name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (541, '0', 'urlmap', 'url', 'Url', 'Url', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (542, '99', 'urlmap', 'memo', '备注', 'memo', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (1717, '99', 'fld', 'pattern', '匹配模式', 'Pattern', 0, 23, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2061, '0', 'sysgroup', 'no', '编码', 'No', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2062, '0', 'sysgroup', 'name', '名称', 'Name', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2063, '0', 'sysgroup', 'type', '说明', 'Type', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2600, '0', 'media', 'major', '主类型', 'major', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (2601, '0', 'media', 'minor', '子类型', 'minor', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (2602, '0', 'media', 'entityid', '实体id', 'entityid', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (2603, '0', 'media', 'filename', '文件名称', 'filename', 0, 4, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2604, '0', 'media', 'title', '文件存储名称', 'title', 0, 5, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2605, '0', 'media', 'uperson', '上传人员', 'uperson', 0, 6, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2606, '0', 'media', 'udate', '上传日期', 'udate', 0, 7, 3, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2607, '0', 'media', 'filelength', '文件长度', 'filelength', 1, 8, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (2608, '0', 'media', 'bz', '备注', 'bz', 0, 9, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2609, '0', 'media', 'fid', 'fid字段', 'fid', 1, 10, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (2610, '0', 'media', 'sys', '系统号', 'Sys', 1, 11, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2611, '0', 'media', 'glid', '关联ID', 'Associated ID', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2612, '0', 'media', 'task', '任务', 'Task', 0, 13, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2613, '0', 'media', 'bustype', '业务类别', 'bustype', 0, 14, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (2620, '0', 'sysrole', 'glid', '关联ID', 'Glid', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2621, '0', 'sysrole', 'creator', '创建者ID', 'Creator', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2622, '0', 'sysrole', 'type', '类型', 'Type', 1, 2, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2623, '0', 'sysrole', 'name', '名称', 'Name', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 2, 32, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2624, '0', 'sysrole', 'memo', '备注', 'Comment', 0, 4, 1, 1, 1, 1, 4, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2625, '0', 'sysrole', 'sys', '系统号', 'System No', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2631, '0', 'userdep', 'organid', '部门ID', 'organid', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2632, '0', 'userdep', 'userid', '用户ID', 'userid', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2633, '0', 'userdep', 'organname', '部门', 'organname', 0, 3, 7, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2634, '0', 'userdep', 'username', '人员', 'username', 0, 4, 7, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (2635, '0', 'userdep', 'position', '职位', 'Position', 0, 5, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (3298, '0', 'fb_borrow', 'bill', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (5560, '0', 'seqbill', 'name', '名称', '', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (5561, '0', 'seqbill', 'curtime', '当前计时', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (5562, '0', 'seqbill', 'curval', '当前序号', '', 1, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (5563, '0', 'seqbill', 'len', '序号长度', '', 1, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (5564, '0', 'seqbill', 'ptn', '编号模板', '', 0, 5, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (5565, '0', 'seqbill', 'timptn', '计时模板', '', 0, 6, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (5566, '0', 'seqbill', 'memo', '备注', '', 0, 7, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6749, '0', 'proccomp', 'instime', '完成时间', '', 0, 0, 6, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (6750, '0', 'proccomp', 'userno', '用户名', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6751, '0', 'proccomp', 'prockey', '流程Key', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6752, '0', 'proccomp', 'busid', '业务表ID', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6753, '0', 'proccomp', 'reason', '申请事由', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6770, '0', 'procs', 'sys', '系统号', '', 1, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6771, '0', 'procs', 'namee', '流程英文名', '', 0, 2, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6772, '0', 'procs', 'namec', '流程中文名', '', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (6773, '0', 'procs', 'disporder', '显示顺序', '', 1, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6774, '0', 'procs', 'grp', '功能组', '', 0, 5, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6775, '0', 'procs', 'prockey', '流程Key', '', 0, 6, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (6776, '0', 'procs', 'bill', '工单名字', '', 0, 7, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (6777, '0', 'procs', 'procid', '流程Id', '', 0, 8, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6778, '0', 'procs', 'tabname', '表名', '', 0, 9, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6779, '0', 'procs', 'proccls', '流程处理类', '', 0, 10, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6780, '0', 'procs', 'plugins', '插件', '', 0, 11, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6781, '0', 'procs', 'hastask', '同步状态', '', 1, 12, 2, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6782, '0', 'procs', 'attach', '需要附件', '', 1, 13, 2, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6783, '0', 'procs', 'hascomp', '完结通知', '', 1, 14, 2, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6784, '0', 'procs', 'title', '标题', '', 0, 15, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (6785, '0', 'procs', 'icon', '图标', '', 0, 16, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7549, '0', 'user1', 'glid', '关联ID', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7550, '0', 'user1', 'creator', '创建者ID', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7551, '0', 'user1', 'no', '帐号', '', 0, 3, 11, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7552, '0', 'user1', 'name', '姓名', '', 0, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7553, '0', 'user1', 'fno', '财务编号', '', 0, 5, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7554, '0', 'user1', 'hrno', '人力编号', '', 0, 6, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7555, '0', 'user1', 'nickname', '昵称', '', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7556, '0', 'user1', 'gender', '性别', '', 1, 8, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7557, '0', 'user1', 'email', 'EMail', '', 0, 9, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/\\w[-\\w.+]*@([A-Za-z0-9][-A-Za-z0-9]+\\.)+[A-Za-z]{2,14}$/');
INSERT INTO `fld` VALUES (7558, '0', 'user1', 'cell', '手机号码', '', 0, 10, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/0?(13|14|15|17|18)[0-9]{9}$/');
INSERT INTO `fld` VALUES (7559, '0', 'user1', 'telno', '办公电话', '', 0, 11, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7560, '0', 'user1', 'faxno', '传真号码', '', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7561, '0', 'user1', 'address', '家庭地址', '', 0, 13, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7562, '0', 'user1', 'zipcode', '邮政编码', '', 0, 14, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/\\d{6}$/');
INSERT INTO `fld` VALUES (7563, '0', 'user1', 'jjlxr', '紧急联系人', '', 0, 15, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7564, '0', 'user1', 'jjlxdh', '紧急联系电话', '', 0, 16, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/0?(13|14|15|17|18)[0-9]{9}$/');
INSERT INTO `fld` VALUES (7565, '0', 'user1', 'memo', '备注', '', 0, 17, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7566, '0', 'oa_workday', 'rq', '日期', '', 0, 1, 3, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7567, '0', 'oa_workday', 'work', '是否工作', '', 1, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7568, '0', 'oa_workday', 'memo', '备注', '', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7569, '0', 'oa_week', 'sdate', '起始日期', '', 0, 1, 3, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7570, '0', 'oa_week', 'edate', '结束日期', '', 0, 2, 3, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7571, '0', 'oa_week', 'title', '周次', '', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7572, '0', 'oa_asset', 'no', '编码', '', 0, 1, 11, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7573, '0', 'oa_asset', 'ddno', '地大编码', '', 0, 2, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7574, '0', 'oa_asset', 'type', '类型', '', 0, 3, 6, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7575, '0', 'oa_asset', 'model', '型号', '', 0, 4, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7576, '0', 'oa_asset', 'detail', '配置详情', '', 0, 5, 1, 1, 1, 1, 3, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7577, '0', 'oa_asset', 'rq', '购买日期', '', 0, 6, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7578, '0', 'oa_asset', 'zjrq', '折旧期限', '', 0, 7, 3, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7579, '0', 'oa_asset', 'total', '原值', '', 1, 8, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7580, '0', 'oa_asset', 'value', '公司出资', '', 1, 9, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7581, '0', 'oa_asset', 'zjye', '折旧余额', '', 1, 10, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7582, '0', 'oa_asset', 'hgrid', '合购人ID', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7583, '0', 'oa_asset', 'hgr', '合购人', '', 0, 12, 7, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7584, '0', 'oa_asset', 'userid', '用户ID', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7585, '0', 'oa_asset', 'name', '领用人', '', 0, 14, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7586, '0', 'oa_asset', 'lyrq', '领用日期', '', 0, 15, 3, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7587, '0', 'oa_asset', 'purpose', '用途', '', 0, 16, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7588, '0', 'oa_asset', 'place', '放置地点', '', 0, 17, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7589, '0', 'oa_asset', 'ip', 'IP地址', '', 0, 18, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7590, '0', 'oa_asset', 'mac', 'MAC地址', '', 0, 19, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7591, '0', 'oa_asset', 'disk', '磁盘序列号', '', 0, 20, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7592, '0', 'oa_asset', 'os', '操作系统', '', 0, 21, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7593, '0', 'oa_asset', 'secret', '密级', '', 0, 22, 6, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7594, '0', 'oa_asset', 'inuse', '在用', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '1', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7595, '0', 'oa_assetuse', 'assetid', 'assetid', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7596, '0', 'oa_assetuse', 'userid', 'userid', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7597, '0', 'oa_assetuse', 'name', '姓名', '', 0, 3, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7598, '0', 'oa_assetuse', 'lyrq', '领用日期', '', 0, 4, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7599, '0', 'oa_assetuse', 'ghrq', '归还日期', '', 0, 5, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7600, '0', 'oa_gift', 'name', '名称', '', 0, 1, 1, 1, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7601, '0', 'oa_gift', 'model', '型号', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7602, '0', 'oa_gift', 'value', '价格', '', 1, 3, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7603, '0', 'oa_gift', 'des', '描述', '', 0, 4, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7604, '0', 'oa_gift', 'total', '库存数量', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7605, '0', 'oa_giftin', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7606, '0', 'oa_giftin', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7607, '0', 'oa_giftin', 'name', '姓名', '', 0, 3, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7608, '0', 'oa_giftin', 'rq', '入库日期', '', 0, 4, 3, 0, 0, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7609, '0', 'oa_giftin', 'total', '入库数量', '', 1, 5, 1, 1, 0, 0, 1, '1', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7610, '0', 'oa_giftin', 'memo', '备注', '', 0, 6, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7611, '0', 'oa_giftuse', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7612, '0', 'oa_giftuse', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7613, '0', 'oa_giftuse', 'name', '姓名', '', 0, 3, 7, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7614, '0', 'oa_giftuse', 'rq', '领用日期', '', 0, 4, 3, 0, 0, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7615, '0', 'oa_giftuse', 'total', '领用数量', '', 1, 5, 1, 1, 0, 0, 1, '1', NULL, '1', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7616, '0', 'oa_giftuse', 'memo', '备注', '', 0, 6, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7617, '0', 'oa_giftd', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7618, '0', 'oa_giftd', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7619, '0', 'oa_giftd', 'fno', '财务编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${fno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7620, '0', 'oa_giftd', 'depart', '部门', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7621, '0', 'oa_giftd', 'position', '职务', '', 0, 5, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7622, '0', 'oa_giftd', 'reason', '事由', '', 0, 6, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7623, '0', 'oa_giftd', 'rq', '申请日期', '', 0, 8, 3, 0, 0, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7624, '0', 'oa_giftd', 'purpose', '用途', '', 0, 9, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7625, '0', 'oa_giftd', 'detail', '清单', '', 0, 9, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7626, '0', 'oa_giftd', 'memo', '备注', '', 0, 16, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7627, '0', 'oa_giftd', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7628, '0', 'oa_giftd', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7629, '0', 'oa_giftd', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7630, '0', 'oa_bjbdn', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7631, '0', 'oa_bjbdn', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7632, '0', 'oa_bjbdn', 'fno', '财务编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${fno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7633, '0', 'oa_bjbdn', 'depart', '部门', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7634, '0', 'oa_bjbdn', 'position', '职务', '', 0, 5, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7635, '0', 'oa_bjbdn', 'reason', '事由', '', 0, 6, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7636, '0', 'oa_bjbdn', 'rq', '购买日期', '', 0, 7, 3, 1, 1, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7637, '0', 'oa_bjbdn', 'model', '型号', '', 0, 8, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7638, '0', 'oa_bjbdn', 'detail', '详细配置', '', 0, 9, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7639, '0', 'oa_bjbdn', 'total', '价格', '', 1, 10, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7640, '0', 'oa_bjbdn', 'value', '公司出资', '', 1, 11, 1, 0, 0, 1, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7641, '0', 'oa_bjbdn', 'zjnx', '折旧年限(年)', '', 1, 12, 1, 0, 0, 1, 1, NULL, NULL, '4', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7642, '0', 'oa_bjbdn', 'zjye', '折旧余额', '', 1, 13, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7643, '0', 'oa_bjbdn', 'zjrq', '折旧期限', '', 0, 14, 3, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7644, '0', 'oa_bjbdn', 'memo', '备注', '', 0, 15, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7645, '0', 'oa_bjbdn', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7646, '0', 'oa_bjbdn', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7647, '0', 'oa_bjbdn', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7648, '0', 'oa_bjbdn', 'inuse', '在用', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '1', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7649, '0', 'oa_bjbdn', 'effect', '生效', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7650, '0', 'oa_customer', 'name', '名称', '', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7651, '0', 'oa_customer', 'addr', '地址', '', 0, 2, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7652, '0', 'oa_customer', 'zip', '邮政编码', '', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/\\d{6}$/');
INSERT INTO `fld` VALUES (7653, '0', 'oa_customer', 'taxno', '纳税人识别号', '', 0, 4, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7654, '0', 'oa_customer', 'bank', '开户行', '', 0, 5, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7655, '0', 'oa_customer', 'account', '账号', '', 0, 6, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7656, '0', 'oa_customer', 'tel', '电话', '', 0, 7, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7657, '0', 'oa_customer', 'fax', '传真', '', 0, 8, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7658, '0', 'oa_customer', 'url', '网址', '', 0, 9, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/^((https|http|ftp|rtsp|mms)?:\\/\\/)[^\\s]+$/');
INSERT INTO `fld` VALUES (7659, '0', 'oa_customer', 'province', '所在省', '', 0, 10, 9, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7660, '0', 'oa_customer', 'city', '所在市', '', 0, 11, 9, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7661, '0', 'oa_customer', 'memo', '备注', '', 0, 12, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7662, '0', 'oa_customer', 'htno', '最近合同编号', '', 0, 13, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7663, '0', 'oa_contact', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7664, '0', 'oa_contact', 'name', '姓名', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7665, '0', 'oa_contact', 'depart', '部门', '', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7666, '0', 'oa_contact', 'position', '职务', '', 0, 4, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7667, '0', 'oa_contact', 'mobile', '手机', '', 0, 5, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/0?(13|14|15|17|18)[0-9]{9}$/');
INSERT INTO `fld` VALUES (7668, '0', 'oa_contact', 'tel', '电话', '', 0, 6, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7669, '0', 'oa_contact', 'email', '邮箱', '', 0, 7, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/\\w[-\\w.+]*@([A-Za-z0-9][-A-Za-z0-9]+\\.)+[A-Za-z]{2,14}$/');
INSERT INTO `fld` VALUES (7670, '0', 'oa_contact', 'memo', '备注', '', 0, 8, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7671, '0', 'oa_contact', 'inuse', '是否在用', '', 1, 0, 0, 0, 0, 0, 1, NULL, NULL, '1', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7672, '0', 'oa_prj', 'no', '项目编号', '', 0, 1, 11, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7673, '0', 'oa_prj', 'name', '项目名称', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7674, '0', 'oa_prj', 'cjrq', '创建日期', '', 0, 3, 3, 1, 1, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7675, '0', 'oa_prj', 'yjjarq', '预计结案日期', '', 0, 4, 3, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7676, '0', 'oa_prj', 'htid', 'htid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7677, '0', 'oa_prj', 'ht', '合同名称', '', 0, 6, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7678, '0', 'oa_prj', 'custid', 'custid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7679, '0', 'oa_prj', 'cust', '客户名称', '', 0, 8, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7680, '0', 'oa_prj', 'phase', '阶段', '', 0, 9, 2, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7681, '0', 'oa_prj', 'depart', '所属部门', '', 0, 10, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7682, '0', 'oa_prj', 'pmid', 'pmid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7683, '0', 'oa_prj', 'pm', '项目经理', '', 0, 12, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7684, '0', 'oa_prj', 'techid', 'techid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7685, '0', 'oa_prj', 'tech', '技术负责人', '', 0, 14, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7686, '0', 'oa_prj', 'opm', '对方项目经理', '', 0, 15, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7687, '0', 'oa_prj', 'completed', '是否完成', '', 1, 16, 2, 0, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7688, '0', 'oa_prj', 'dirpm', '项目管理目录', '', 0, 17, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7689, '0', 'oa_prj', 'dirdata', '数据目录', '', 0, 18, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7690, '0', 'oa_prj', 'dirfile', '归档目录', '', 0, 19, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7691, '0', 'oa_prj', 'memo', '备注', '', 0, 20, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7692, '0', 'oa_prjmem', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7693, '0', 'oa_prjmem', 'userid', 'userid', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7694, '0', 'oa_prjmem', 'username', '姓名', '', 0, 3, 7, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7695, '0', 'oa_prjmem', 'rol', '角色', '', 0, 4, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7696, '0', 'oa_prjmem', 'memo', '备注', '', 0, 7, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7697, '0', 'oa_prjms', 'id0', 'id0', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7698, '0', 'oa_prjms', 'task', '任务', '', 0, 2, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7699, '0', 'oa_prjms', 'rq', '日期', '', 0, 3, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7700, '0', 'oa_prjms', 'level', '重要程度', '', 1, 4, 2, 1, 1, 0, 1, NULL, NULL, '3', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7701, '0', 'oa_prjms', 'completed', '是否完成', '', 1, 5, 2, 0, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7702, '0', 'oa_prjprob', 'id0', 'id0', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7703, '0', 'oa_prjprob', 'srcid', 'srcid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7704, '0', 'oa_prjprob', 'srcname', '提出人', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7705, '0', 'oa_prjprob', 'srcrq', '提出日期', '', 0, 4, 1, 0, 0, 1, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7706, '0', 'oa_prjprob', 'task', '问题', '', 0, 5, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7707, '0', 'oa_prjprob', 'rq', '解决期限', '', 0, 6, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7708, '0', 'oa_prjprob', 'level', '重要程度', '', 1, 7, 2, 1, 1, 0, 1, NULL, NULL, '3', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7709, '0', 'oa_prjprob', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7710, '0', 'oa_prjprob', 'name', '解决人', '', 0, 9, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7711, '0', 'oa_prjprob', 'resolved', '是否解决', '', 1, 10, 2, 0, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7712, '0', 'oa_prjprob', 'solution', '解决方案', '', 0, 11, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7713, '0', 'oa_prjprob', 'completed', '是否完成', '', 1, 12, 2, 0, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7714, '0', 'oa_prjtask', 'id0', 'id0', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7715, '0', 'oa_prjtask', 'task', '任务', '', 0, 2, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7716, '0', 'oa_prjtask', 'level', '重要程度', '', 1, 3, 2, 1, 1, 0, 1, NULL, NULL, '3', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7717, '0', 'oa_prjtask', 'rq', '解决期限', '', 0, 4, 3, 1, 1, 1, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7718, '0', 'oa_prjtask', 'resolved', '是否解决', '', 1, 5, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7719, '0', 'oa_prjtask', 'dur', '今日工作时长', '', 1, 6, 1, 1, 1, 1, 1, '0', '12', '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7720, '0', 'oa_prjtask', 'solution', '解决方案', '', 0, 7, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7721, '0', 'oa_prjtask', 'completed', '是否完成', '', 1, 8, 2, 0, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7722, '0', 'oa_prjtask', 'durall', '总时长', '', 1, 9, 1, 0, 0, 1, 1, '0', NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7723, '0', 'oa_prjtask', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7724, '0', 'oa_prjtask', 'name', '解决人', '', 0, 11, 9, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7725, '0', 'oa_prjtask', 'srcid', 'srcid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7726, '0', 'oa_prjtask', 'srcname', '提出人', '', 0, 13, 1, 0, 0, 1, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7727, '0', 'oa_prjtask', 'srcrq', '提出日期', '', 0, 14, 1, 0, 0, 1, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7728, '0', 'oa_prjtime', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7729, '0', 'oa_prjtime', 'name', '解决人', '', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7730, '0', 'oa_prjtime', 'task', '任务', '', 0, 3, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7731, '0', 'oa_prjtime', 'level', '重要程度', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, '1', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7732, '0', 'oa_prjtime', 'prjid', 'prjid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7733, '0', 'oa_prjtime', 'prj', '项目名称', '', 0, 6, 9, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7734, '0', 'oa_prjtime', 'rq', '日期', '', 0, 7, 3, 1, 1, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7735, '0', 'oa_prjtime', 'solution', '解决方案', '', 0, 8, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7736, '0', 'oa_prjtime', 'dur', '解决时长', '', 1, 9, 1, 1, 1, 0, 1, '0', '12', NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7737, '0', 'oa_prjcont', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7738, '0', 'oa_prjcont', 'name', '姓名', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7739, '0', 'oa_prjcont', 'depart', '部门', '', 0, 3, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7740, '0', 'oa_prjcont', 'position', '职务', '', 0, 4, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7741, '0', 'oa_prjcont', 'mobile', '手机', '', 0, 5, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/0?(13|14|15|17|18)[0-9]{9}$/');
INSERT INTO `fld` VALUES (7742, '0', 'oa_prjcont', 'tel', '电话', '', 0, 6, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7743, '0', 'oa_prjcont', 'email', '邮箱', '', 0, 7, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, '/\\w[-\\w.+]*@([A-Za-z0-9][-A-Za-z0-9]+\\.)+[A-Za-z]{2,14}$/');
INSERT INTO `fld` VALUES (7744, '0', 'oa_prjcont', 'memo', '备注', '', 0, 8, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7745, '0', 'oa_prjcont', 'inuse', '是否在用', '', 1, 0, 0, 0, 0, 0, 1, NULL, NULL, '1', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7746, '0', 'ht_info', 'no', '合同编号', '', 0, 1, 11, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7747, '0', 'ht_info', 'name', '合同名称', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7748, '0', 'ht_info', 'custid', 'custid', '', 1, 0, 1, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7749, '0', 'ht_info', 'cust', '客户单位', '', 0, 4, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7750, '0', 'ht_info', 'prjid', 'prjid', '', 1, 0, 1, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7751, '0', 'ht_info', 'prj', '项目', '', 0, 6, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7752, '0', 'ht_info', 'qdrq', '签订日期', '', 0, 7, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7753, '0', 'ht_info', 'jarq', '结案日期', '', 0, 7, 3, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7754, '0', 'ht_info', 'value', '合同金额', '', 1, 9, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7755, '0', 'ht_info', 'hdje', '核定金额', '', 1, 10, 1, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7756, '0', 'ht_info', 'kpje', '开票金额', '', 1, 11, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7757, '0', 'ht_info', 'hkje', '回款金额', '', 1, 12, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7758, '0', 'ht_info', 'yszk', '应收账款', '', 1, 13, 1, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7759, '0', 'ht_info', 'wzxje', '未执行金额', '', 1, 14, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7760, '0', 'ht_info', 'zftj', '支付条件', '', 0, 15, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7761, '0', 'ht_info', 'kprq', '开票日期', '', 0, 16, 3, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7762, '0', 'ht_info', 'pz', '票种', '', 0, 17, 6, 1, 1, 1, 1, NULL, NULL, '专票', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7763, '0', 'ht_info', 'sl', '税率', '', 0, 18, 6, 1, 1, 1, 1, NULL, NULL, '6%', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7764, '0', 'ht_info', 'xmfzr', '项目负责人', '', 0, 19, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7765, '0', 'ht_info', 'jsfzr', '技术负责人', '', 0, 20, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7766, '0', 'ht_info', 'xmysqk', '验收情况', '', 0, 21, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7767, '0', 'ht_info', 'xmysbg', '验收报告', '', 0, 22, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7768, '0', 'ht_info', 'zbq', '质保期', '', 0, 23, 3, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7769, '0', 'ht_info', 'zbj', '质保金', '', 0, 24, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7770, '0', 'ht_info', 'sfyshd', '是否有审核单', '', 1, 25, 2, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7771, '0', 'ht_info', 'hdrq', '审核日期', '', 0, 26, 3, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7772, '0', 'ht_info', 'memo', '备注', '', 0, 27, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7773, '0', 'ht_info', 'completed', '是否结束', '', 1, 28, 2, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7774, '0', 'ht_invoice', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7775, '0', 'ht_invoice', 'rq', '开票日期', '', 0, 2, 3, 1, 1, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7776, '0', 'ht_invoice', 'value', '金额', '', 1, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7777, '0', 'ht_pay', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7778, '0', 'ht_pay', 'rq', '付款日期', '', 0, 2, 3, 1, 1, 0, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7779, '0', 'ht_pay', 'value', '金额', '', 1, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7780, '0', 'f_ddbxd', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7781, '0', 'f_ddbxd', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7782, '0', 'f_ddbxd', 'fno', '财务编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${fno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7783, '0', 'f_ddbxd', 'depart', '部门', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7784, '0', 'f_ddbxd', 'position', '职务', '', 0, 5, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7785, '0', 'f_ddbxd', 'reason', '事由', '', 0, 6, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7786, '0', 'f_ddbxd', 'total', '报销金额', '', 1, 7, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7787, '0', 'f_ddbxd', 'rq', '报销日期', '', 0, 10, 3, 0, 0, 1, 1, NULL, NULL, '${today}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7788, '0', 'f_ddbxd', 'memo', '备注', '', 0, 11, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7789, '0', 'f_ddbxd', 'prjid', 'prjid', '', 1, 0, 1, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7790, '0', 'f_ddbxd', 'prj', '归属项目', '', 0, 13, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7791, '0', 'f_ddbxd', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7792, '0', 'f_ddbxd', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7793, '0', 'f_ddbxd', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7794, '0', 'f_ddbxd', 'effect', '生效', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7795, '0', 'hr_leave', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7796, '0', 'hr_leave', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7797, '0', 'hr_leave', 'hrno', '人力编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${hrno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7798, '0', 'hr_leave', 'depart', '部门', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7799, '0', 'hr_leave', 'position', '职务', '', 0, 5, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7800, '0', 'hr_leave', 'type', '请假类型', '', 1, 6, 2, 1, 1, 0, 1, NULL, NULL, '1', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7801, '0', 'hr_leave', 'reason', '请假事由', '', 0, 7, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7802, '0', 'hr_leave', 'starttime', '起始时间', '', 0, 8, 5, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7803, '0', 'hr_leave', 'endtime', '结束时间', '', 0, 9, 5, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7804, '0', 'hr_leave', 'total', '请假天数', '', 1, 10, 1, 0, 0, 0, 1, '0', NULL, '0', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7805, '0', 'hr_leave', 'memo', '备注', '', 0, 11, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7806, '0', 'hr_leave', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7807, '0', 'hr_leave', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7808, '0', 'hr_leave', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7809, '0', 'hr_leave', 'effect', '生效', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7810, '0', 'hr_bustrip', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7811, '0', 'hr_bustrip', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7812, '0', 'hr_bustrip', 'hrno', '人力编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${hrno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7813, '0', 'hr_bustrip', 'depart', '部门', '', 0, 3, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7814, '0', 'hr_bustrip', 'position', '职务', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7815, '0', 'hr_bustrip', 'reason', '出差事由', '', 0, 6, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7816, '0', 'hr_bustrip', 'starttime', '起始时间', '', 0, 7, 5, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7817, '0', 'hr_bustrip', 'endtime', '结束时间', '', 0, 8, 5, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7818, '0', 'hr_bustrip', 'total', '出差天数', '', 1, 10, 1, 0, 0, 0, 1, '0', NULL, '0', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7819, '0', 'hr_bustrip', 'dest', '目的地', '', 0, 9, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7820, '0', 'hr_bustrip', 'vehicle', '交通工具', '', 0, 10, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7821, '0', 'hr_bustrip', 'alp', '同行人员', '', 0, 11, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7822, '0', 'hr_bustrip', 'prjid', '归属项目ID', '', 1, 0, 1, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7823, '0', 'hr_bustrip', 'prj', '归属项目', '', 0, 13, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7824, '0', 'hr_bustrip', 'memo', '备注', '', 0, 14, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7825, '0', 'hr_bustrip', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7826, '0', 'hr_bustrip', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7827, '0', 'hr_bustrip', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7828, '0', 'hr_bustrip', 'effect', '生效', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7829, '0', 'hr_out', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7830, '0', 'hr_out', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7831, '0', 'hr_out', 'hrno', '人力编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${hrno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7832, '0', 'hr_out', 'depart', '部门', '', 0, 3, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7833, '0', 'hr_out', 'position', '职务', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7834, '0', 'hr_out', 'reason', '外出事由', '', 0, 6, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7835, '0', 'hr_out', 'rq', '外出日期', '', 0, 7, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7836, '0', 'hr_out', 'outtime', '出公司时间', '', 0, 8, 12, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7837, '0', 'hr_out', 'intime', '回公司时间', '', 0, 9, 12, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7838, '0', 'hr_out', 'zdk', '早打卡', '', 1, 10, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7839, '0', 'hr_out', 'wdk', '晚打卡', '', 1, 11, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7840, '0', 'hr_out', 'prjid', '归属项目ID', '', 1, 0, 1, 1, 1, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7841, '0', 'hr_out', 'prj', '归属项目', '', 0, 13, 7, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7842, '0', 'hr_out', 'memo', '备注', '', 0, 14, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7843, '0', 'hr_out', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7844, '0', 'hr_out', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7845, '0', 'hr_out', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7846, '0', 'hr_out', 'effect', '生效', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7847, '0', 'hr_punch', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7848, '0', 'hr_punch', 'name', '姓名', '', 0, 2, 1, 0, 0, 0, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7849, '0', 'hr_punch', 'hrno', '人力编号', '', 0, 3, 1, 0, 0, 1, 1, NULL, NULL, '${hrno}', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7850, '0', 'hr_punch', 'depart', '部门', '', 0, 3, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7851, '0', 'hr_punch', 'position', '职务', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7852, '0', 'hr_punch', 'reason', '事由', '', 0, 5, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7853, '0', 'hr_punch', 'rq', '忘打卡日期', '', 0, 6, 3, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7854, '0', 'hr_punch', 'zdk', '补上班', '', 1, 7, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7855, '0', 'hr_punch', 'wdk', '补下班', '', 1, 8, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7856, '0', 'hr_punch', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7857, '0', 'hr_punch', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7858, '0', 'hr_punch', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7859, '0', 'hr_punch', 'effect', '生效', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7860, '0', 'wm_meet', 'userid', 'userid', '', 1, 0, 1, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7861, '0', 'wm_meet', 'depart', '部门', '', 0, 2, 7, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7862, '0', 'wm_meet', 'title', '标题', '', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7863, '0', 'wm_meetmem', 'id0', 'id0', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7864, '0', 'wm_meetmem', 'userid', 'userid', '', 1, 0, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7865, '0', 'wm_meetmem', 'name', '姓名', '', 0, 3, 7, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7866, '0', 'wm_meetmem', 'memo', '备注', '', 0, 4, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7867, '0', 'wm_meetrec', 'id0', 'id0', '', 1, 0, 0, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7868, '0', 'wm_meetrec', 'weekid', 'weekid', '', 1, 0, 0, 0, 0, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7869, '0', 'wm_meetrec', 'userid', 'userid', '', 1, 0, 0, 0, 0, 0, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7870, '0', 'wm_meetrec', 'content', '内容', '', 0, 3, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7871, '0', 'wm_meetrec', 'completed', '是否完成', '', 1, 4, 2, 0, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7872, '0', 'oa_seal', 'userid', 'userid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7873, '0', 'oa_seal', 'name', '申请人', '', 0, 2, 1, 0, 0, 1, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7874, '0', 'oa_seal', 'depart', '部门', '', 0, 3, 8, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7875, '0', 'oa_seal', 'rq', '申请日期', '', 0, 4, 3, 0, 0, 0, 1, NULL, NULL, '${now}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7876, '0', 'oa_seal', 'type', '类型', '', 0, 5, 2, 1, 1, 0, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7877, '0', 'oa_seal', 'reason', '申请事由', '', 0, 6, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7878, '0', 'oa_seal', 'memo', '备注', '', 0, 7, 1, 1, 1, 1, 4, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7879, '0', 'oa_seal', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7880, '0', 'oa_seal', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7881, '0', 'oa_seal', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7882, '0', 'oa_htps', 'userid', 'userid', '', 1, 0, 1, 0, 0, 1, 1, NULL, NULL, '${userid}', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7883, '0', 'oa_htps', 'name', '申请人', '', 0, 2, 1, 0, 0, 1, 1, NULL, NULL, '${username}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7884, '0', 'oa_htps', 'depart', '部门', '', 0, 3, 8, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7885, '0', 'oa_htps', 'position', '职务', '', 0, 4, 8, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7886, '0', 'oa_htps', 'rq', '申请日期', '', 0, 5, 3, 0, 0, 0, 1, NULL, NULL, '${now}', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7887, '0', 'oa_htps', 'type', '类型', '', 0, 6, 6, 1, 1, 0, 1, NULL, NULL, '销售合同', 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7888, '0', 'oa_htps', 'reason', '申请事由', '', 0, 7, 10, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7889, '0', 'oa_htps', 'abstract', '摘要', '', 0, 8, 1, 1, 1, 1, 6, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7890, '0', 'oa_htps', 'completed', '是否完成', '', 1, 21, 2, 0, 0, 1, 1, NULL, NULL, '0', 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7891, '0', 'oa_htps', 'procInstId', '工单号', '', 0, 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7892, '0', 'oa_htps', 'bill', '工单号', '', 0, 23, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7893, '0', 'oa_link', 'cata', '类别', '', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7894, '0', 'oa_link', 'title', '标题', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7895, '0', 'oa_link', 'url', 'URL', '', 0, 3, 1, 1, 1, 0, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, '/^((https|http|ftp|rtsp|mms)?:\\/\\/)[^\\s]+$/');
INSERT INTO `fld` VALUES (7896, '0', 'oa_link', 'memo', '备注', '', 0, 4, 1, 1, 1, 1, 2, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7897, '0', 'oa_area', 'parent', '上级', '', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7898, '0', 'oa_area', 'name', '名称', '', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 1, 0, 0, NULL);
INSERT INTO `fld` VALUES (7899, '0', 'oa_area', 'disporder', '显示顺序', '', 1, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 2, 0, 0, NULL);
INSERT INTO `fld` VALUES (7905, '99', 'entity', 'func', '功能配置', 'Func', 0, 14, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7948, '99', 'plugin', 'sys', '系统号', 'System No', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7949, '99', 'plugin', 'cata', '分类', 'Cata', 0, 2, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7950, '99', 'plugin', 'name', '名称', 'Name', 0, 3, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7951, '99', 'plugin', 'pname', '父插件', 'PName', 0, 4, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7952, '99', 'plugin', 'titlee', '插件英文标题', 'Title(English)', 0, 5, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7953, '99', 'plugin', 'titlec', '插件中文标题', 'Title(Chinese)', 0, 6, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7954, '99', 'plugin', 'autorun', '是否自动运行', 'Auto Run', 1, 7, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7955, '99', 'plugin', 'closeable', '是否可关闭', 'Closeable', 1, 8, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7956, '99', 'plugin', 'prereq', '前置插件', 'Pre-Request', 0, 9, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7957, '99', 'plugin', 'uitype', '界面类型', 'Ui Type', 1, 10, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7958, '99', 'plugin', 'modal', '是否模态对话框', 'Modal Dialg', 1, 11, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7959, '99', 'plugin', 'container', '插件容器', 'Container', 0, 12, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7960, '99', 'plugin', 'runn', '多例运行', 'Multiple', 1, 13, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7961, '99', 'plugin', 'dir', '插件所在目录', 'Dir', 0, 14, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7962, '99', 'plugin', 'classurl', '类文件', 'Class File', 0, 15, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7963, '99', 'plugin', 'icon', '图标文件', 'Icon', 0, 16, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7964, '99', 'plugin', 'align', '对齐方式', 'Align Type', 1, 17, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7965, '99', 'plugin', 'width', '宽度', 'Width', 1, 18, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7966, '99', 'plugin', 'height', '高度', 'Height', 1, 19, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7967, '99', 'plugin', 'button', '插件按钮', 'button', 0, 20, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7968, '99', 'plugin', 'initpara', '初始化参数', 'Init Param', 0, 21, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7969, '99', 'sysuser', 'no', '登录名', 'Loging ID', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7970, '99', 'sysuser', 'name', '姓名', 'Name', 0, 2, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7971, '99', 'sysuser', 'ismanager', '是否管理员', 'Is Manager', 1, 3, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7972, '99', 'sysuser', 'ischeck', '是否审核员', 'Is Check', 1, 0, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7973, '99', 'sysuser', 'isreader', '是否只读用户', 'Only Reader', 1, 5, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7974, '99', 'sysuser', 'imei', 'IMEI码', 'IMEI Code', 1, 6, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7975, '99', 'sysuser', 'tools', '常用工具', 'Tools', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7976, '99', 'sysuser', 'lastwin', '最后窗口', 'Window', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7977, '99', 'sysuser', 'note', '自定义标注', 'Note', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7978, '99', 'sysuser', 'password', '密码', 'password', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7979, '99', 'sysuser', 'vrytime', '验证时间', 'vrytime', 0, 0, 5, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (7980, '99', 'sysuser', 'vrycode', '验证码', 'vrycode', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8009, '21', 'types', 'type', '综合知识、案列分析、论文写作、知识考点', 'type', 0, 0, 1, 1, 1, 1, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8010, '21', 'shop', 'name', '商品名称', 'name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8011, '21', 'shop', 'price', '价格', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8012, '21', 'shop', 'oldprice', '旧价格', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8013, '21', 'shop', 'xl', '销量', 'xl', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8014, '21', 'shop', 'kc', '库存', 'kc', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8015, '21', 'shop', 'liull', '浏览量', 'liull', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8016, '21', 'shop', 'size', '大小', 'size', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8017, '21', 'shop', 'color', '颜色', 'color', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8018, '21', 'shop', 'yhj', '优惠券', 'yhj', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8019, '21', 'shop', 'zx', '促销', 'zx', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8020, '21', 'shop', 'fw', '服务', 'fw', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8021, '21', 'shop', 'url', '图片简图', 'url', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8022, '21', 'shop', 'bg', '背景图片', 'url', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8023, '21', 'shop', 'type', '类型', 'type', 0, 1, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8024, '21', 'shop', 'tg', '几人团购', 'tg', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8025, '21', 'evalutate', 'content', '评价内容', 'content', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8026, '21', 'evalutate', 'time', '创建时间', 'time', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8027, '21', 'evalutate', 'shopid', '商品id', 'shopid', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8028, '21', 'evalutate', 'userid', '用户id', 'userid', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8029, '21', 'evalutate', 'username', '用户名称', 'username', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8030, '21', 'evalutate', 'img', '用户头像', 'userimg', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8031, '21', 'evalutate', 'lx', '购买类型', 'lx', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8032, '21', 'shop', 'shopname', '商品名称', 'shopname', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8033, '21', 'shop', 'cxje', '促销金额', 'cxje', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8034, '21', 'shop', 'shopurl', '商品名称', 'shopurl', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8035, '21', 'shop', 'kdfy', '快递费用', 'kdfy', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8036, '21', 'orderinfo', 'shopid', '商品ID', 'shopid', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8037, '21', 'orderinfo', 'price', '实付金额', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8038, '21', 'orderinfo', 'consigneename', '联系人名称', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8039, '21', 'orderinfo', 'consigneemobile', '联系人电话', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8040, '21', 'orderinfo', 'provincecityarea', '省份', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8043, '21', 'orderinfo', 'consigneeaddress', '详细地址', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8044, '21', 'orderinfo', 'orderno', '订单号', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8045, '21', 'orderinfo', 'state', '状态', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8046, '21', 'orderinfo', 'time', '订单创建时间', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8047, '21', 'orderinfo', 'userid', '用户ID', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8050, '21', 'seckill', 'name', '商品名称', 'name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8051, '21', 'seckill', 'price', '价格', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8052, '21', 'seckill', 'oldprice', '旧价格', 'price', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8053, '21', 'seckill', 'xl', '销量', 'xl', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8054, '21', 'seckill', 'kc', '库存', 'kc', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8055, '21', 'seckill', 'liull', '浏览量', 'liull', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8056, '21', 'seckill', 'size', '大小', 'size', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8057, '21', 'seckill', 'color', '颜色', 'color', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8058, '21', 'seckill', 'yhj', '优惠券', 'yhj', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8059, '21', 'seckill', 'zx', '促销', 'zx', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8060, '21', 'seckill', 'fw', '服务', 'fw', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8061, '21', 'seckill', 'url', '图片简图', 'url', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8062, '21', 'seckill', 'bg', '背景图片', 'url', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8063, '21', 'seckill', 'type', '类型', 'type', 0, 1, 2, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8064, '21', 'seckill', 'tg', '几人团购', 'tg', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8065, '21', 'seckill', 'shopname', '店铺名称', 'shopname', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8066, '21', 'seckill', 'shopimg', '店铺头像', 'shopimg', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8067, '21', 'seckill', 'cxje', '促销金额', 'cxje', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8068, '21', 'seckill', 'kdfy', '快递费用', 'kdfy', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8069, '21', 'cat', 'layer', '图层ID', 'layer', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8070, '21', 'cat', 'glid', '关联ID', 'glid', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8071, '21', 'cat', 'name', '名称', 'name', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8072, '21', 'cat', 'picture', '图片', 'picture', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8073, '21', 'cat', 'type', '类型', 'type', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8074, '21', 'shopcart', 'shopid', '商品id', 'shopid', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8075, '21', 'shopcart', 'userid', '用户id', 'userid', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8076, '21', 'shopcart', 'nums', '数量', 'nums', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8077, '21', 'shopcart', 'state', '状态', 'state', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8078, '21', 'shopcart', 'time', '加入时间', 'time', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8081, '21', 'shopcart', 'sizecolor', '大小 颜色', 'sizecolor', 1, 11, 1, 1, 1, 0, 1, '0', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8082, '21', 'history', 'shopid', '商品id', 'shopid', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8083, '21', 'history', 'userid', '用户id', 'userid', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8084, '21', 'history', 'state', '状态', 'state', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8085, '21', 'history', 'time', '状态', 'time', 0, 1, 1, 1, 1, 0, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8086, '21', 'orderinfo', 'nums', '数量', 'nums', 1, 5, 1, 1, 1, 0, 1, '1', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8087, '21', 'orderinfo', 'size', '大小', 'size', 1, 5, 1, 1, 1, 0, 1, '1', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
INSERT INTO `fld` VALUES (8088, '21', 'orderinfo', 'color', '颜色', 'color', 1, 5, 1, 1, 1, 0, 1, '1', NULL, NULL, 0, 0, NULL, NULL, 0, 0, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for fldvalue
-- ----------------------------
DROP TABLE IF EXISTS `fldvalue`;
CREATE TABLE `fldvalue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sys` varchar(16) NOT NULL,
  `tabname` varchar(32) NOT NULL,
  `colname` varchar(32) NOT NULL,
  `disporder` decimal(5,0) NOT NULL,
  `dbvalue` varchar(32) NOT NULL,
  `dispc` varchar(128) NOT NULL,
  `dispe` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fldvalue_tabcoldb` (`tabname`,`colname`,`dbvalue`),
  KEY `fldvalue_sys` (`sys`)
) ENGINE=InnoDB AUTO_INCREMENT=1665 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of fldvalue
-- ----------------------------
BEGIN;
INSERT INTO `fldvalue` VALUES (35, '0', 'oa_leave', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (36, '0', 'oa_leave', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (37, '0', 'oa_leave', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (38, '0', 'oa_leave', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (39, '0', 'oa_leave', 'type', 1, '1', '事假', '');
INSERT INTO `fldvalue` VALUES (40, '0', 'oa_leave', 'type', 2, '2', '病假', '');
INSERT INTO `fldvalue` VALUES (41, '0', 'oa_leave', 'type', 3, '0', '年假', '');
INSERT INTO `fldvalue` VALUES (42, '0', 'oa_leave', 'type', 4, '3', '婚假', '');
INSERT INTO `fldvalue` VALUES (43, '0', 'oa_leave', 'type', 5, '4', '产假', '');
INSERT INTO `fldvalue` VALUES (44, '0', 'oa_leave', 'type', 6, '5', '丧假', '');
INSERT INTO `fldvalue` VALUES (45, '0', 'wm_meetuser', 'name', 1, 'BS', 'plugin:SelOrganUser,field:namec,fieldDisp:namec,#{userid}:id', '');
INSERT INTO `fldvalue` VALUES (84, '0', 'public', 'rptfmt', 1, 'xls', 'EXCEL', 'EXCEL');
INSERT INTO `fldvalue` VALUES (85, '0', 'public', 'rptfmt', 2, 'pdf', 'PDF', 'PDF');
INSERT INTO `fldvalue` VALUES (86, '0', 'public', 'rptfmt', 3, 'html', 'HTML', 'HTML');
INSERT INTO `fldvalue` VALUES (87, '0', 'public', 'rptfmt', 4, 'csv', 'CSV', 'CSV');
INSERT INTO `fldvalue` VALUES (88, '0', 'public', 'rptfmt', 5, 'rtf', 'RTF', 'RTF');
INSERT INTO `fldvalue` VALUES (89, '0', 'public', 'rptfmt', 6, 'odt', 'ODT', 'ODT');
INSERT INTO `fldvalue` VALUES (90, '0', 'public', 'rptfmt', 7, 'jpeg', 'JPEG', 'JPEG');
INSERT INTO `fldvalue` VALUES (91, '0', 'entity', 'domain', 1, '1', '教育', 'Edu');
INSERT INTO `fldvalue` VALUES (92, '0', 'entity', 'domain', 2, '99', '配置', 'Config');
INSERT INTO `fldvalue` VALUES (93, '0', 'entity', 'type', 1, '1', '表', 'Table');
INSERT INTO `fldvalue` VALUES (94, '0', 'entity', 'type', 2, '2', '点', 'Point');
INSERT INTO `fldvalue` VALUES (95, '0', 'entity', 'type', 3, '3', '线', 'Line');
INSERT INTO `fldvalue` VALUES (96, '0', 'entity', 'type', 4, '4', '面', 'Polygon');
INSERT INTO `fldvalue` VALUES (97, '0', 'entity', 'log', 1, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (98, '0', 'entity', 'log', 2, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (99, '99', 'fld', 'isnum', 1, '1', '是', 'Yes');
INSERT INTO `fldvalue` VALUES (100, '99', 'fld', 'isnum', 2, '0', '否', 'No');
INSERT INTO `fldvalue` VALUES (101, '99', 'fld', 'disptype', 1, '1', '文本', 'Edit');
INSERT INTO `fldvalue` VALUES (102, '99', 'fld', 'disptype', 2, '2', '下拉框', 'DropList');
INSERT INTO `fldvalue` VALUES (103, '99', 'fld', 'disptype', 3, '3', '日期', 'Date');
INSERT INTO `fldvalue` VALUES (104, '99', 'fld', 'disptype', 4, '4', '富文本', 'Rich Text');
INSERT INTO `fldvalue` VALUES (105, '99', 'fld', 'disptype', 5, '5', '日期+时间', 'Date + Time');
INSERT INTO `fldvalue` VALUES (106, '99', 'fld', 'disptype', 6, '6', '下拉(可改)', 'DropDown');
INSERT INTO `fldvalue` VALUES (107, '99', 'fld', 'newedit', 1, '1', '是', 'Yes');
INSERT INTO `fldvalue` VALUES (108, '99', 'fld', 'newedit', 2, '0', '否', 'No');
INSERT INTO `fldvalue` VALUES (109, '99', 'fld', 'editable', 1, '1', '是', 'Yes');
INSERT INTO `fldvalue` VALUES (110, '99', 'fld', 'editable', 2, '0', '否', 'No');
INSERT INTO `fldvalue` VALUES (111, '99', 'fld', 'nullable', 1, '1', '是', 'Yes');
INSERT INTO `fldvalue` VALUES (112, '99', 'fld', 'nullable', 2, '0', '否', 'No');
INSERT INTO `fldvalue` VALUES (113, '99', 'fld', 'qrylevel', 1, '1', '第1级', 'Level 1');
INSERT INTO `fldvalue` VALUES (114, '99', 'fld', 'qrylevel', 2, '2', '第2级', 'Level 2');
INSERT INTO `fldvalue` VALUES (122, '99', 'plugin', 'autorun', 1, '0', '不自动运行', 'Non-Automatic');
INSERT INTO `fldvalue` VALUES (123, '99', 'plugin', 'autorun', 2, '1', '自动运行', 'Automatic');
INSERT INTO `fldvalue` VALUES (124, '99', 'plugin', 'closeable', 1, '1', '可关闭', 'Yes');
INSERT INTO `fldvalue` VALUES (125, '99', 'plugin', 'closeable', 2, '0', '不可关闭', 'No');
INSERT INTO `fldvalue` VALUES (126, '99', 'plugin', 'uitype', 1, '1', '对话框', 'Dialog');
INSERT INTO `fldvalue` VALUES (127, '99', 'plugin', 'uitype', 2, '2', 'TAB页显示', 'Tab Page');
INSERT INTO `fldvalue` VALUES (128, '99', 'plugin', 'uitype', 3, '3', '页面嵌入', 'In A Container');
INSERT INTO `fldvalue` VALUES (129, '99', 'plugin', 'modal', 1, '0', '非模态', 'Modaless');
INSERT INTO `fldvalue` VALUES (130, '99', 'plugin', 'modal', 2, '1', '模态', 'Modal');
INSERT INTO `fldvalue` VALUES (131, '99', 'plugin', 'runn', 1, '0', '单例运行', 'Single');
INSERT INTO `fldvalue` VALUES (132, '99', 'plugin', 'runn', 2, '1', '多例运行', 'Multiple');
INSERT INTO `fldvalue` VALUES (133, '99', 'plugin', 'align', 1, '0', '居中', 'Center');
INSERT INTO `fldvalue` VALUES (134, '99', 'plugin', 'align', 2, '-1', '左对齐', 'Left');
INSERT INTO `fldvalue` VALUES (135, '99', 'plugin', 'align', 3, '1', '右对齐', 'Right');
INSERT INTO `fldvalue` VALUES (136, '0', 'funcgrp', 'target', 1, 'menu', '菜单', 'Menu');
INSERT INTO `fldvalue` VALUES (137, '0', 'funcgrp', 'target', 2, 'toolbar', '工具条', 'Toolbar');
INSERT INTO `fldvalue` VALUES (138, '0', 'user1', 'gender', 1, '0', '女', 'Female');
INSERT INTO `fldvalue` VALUES (139, '0', 'user1', 'gender', 2, '1', '男', 'Male');
INSERT INTO `fldvalue` VALUES (140, '0', 'sysuser', 'ismanager', 1, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (141, '0', 'sysuser', 'ismanager', 2, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (142, '0', 'sysuser', 'isreader', 1, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (143, '0', 'sysuser', 'isreader', 2, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (152, '99', 'terrain', 'visible', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (153, '99', 'terrain', 'visible', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (154, '99', 'wms', 'baseLayer', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (155, '99', 'wms', 'baseLayer', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (156, '99', 'wms', 'visible', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (157, '99', 'wms', 'visible', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (158, '99', 'wms', 'isconfig', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (159, '99', 'wms', 'isconfig', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (160, '99', 'wms', 'selectable', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (161, '99', 'wms', 'selectable', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (162, '99', 'wfs', 'baseLayer', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (163, '99', 'wfs', 'baseLayer', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (164, '99', 'layer', 'visible', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (165, '99', 'layer', 'visible', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (166, '99', 'layer', 'isconfig', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (167, '99', 'layer', 'isconfig', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (168, '99', 'layer', 'isattach', 1, '1', '是', 'True');
INSERT INTO `fldvalue` VALUES (169, '99', 'layer', 'isattach', 2, '0', '否', 'False');
INSERT INTO `fldvalue` VALUES (170, '99', 'mapara', 'geotype', 1, '1', '表格', 'Table');
INSERT INTO `fldvalue` VALUES (171, '99', 'mapara', 'geotype', 2, '2', '点', 'Point');
INSERT INTO `fldvalue` VALUES (172, '99', 'mapara', 'geotype', 3, '3', '线', 'Line');
INSERT INTO `fldvalue` VALUES (173, '99', 'mapara', 'geotype', 4, '4', '面', 'Polygon');
INSERT INTO `fldvalue` VALUES (174, '99', 'mapara', 'source', 1, '1', '符号库', 'Symbol');
INSERT INTO `fldvalue` VALUES (175, '99', 'mapara', 'source', 2, '2', '矢量符号', 'Vector');
INSERT INTO `fldvalue` VALUES (176, '99', 'mapara', 'source', 3, '3', '图标', 'Icon');
INSERT INTO `fldvalue` VALUES (177, '99', 'operlog', 'opertype', 1, '1', '插入', 'Insert');
INSERT INTO `fldvalue` VALUES (178, '99', 'operlog', 'opertype', 2, '2', '删除', 'Delete');
INSERT INTO `fldvalue` VALUES (179, '99', 'operlog', 'opertype', 3, '3', '修改', 'Update');
INSERT INTO `fldvalue` VALUES (180, '99', 'sysds', 'type', 1, 'Oracle', 'Oracle', 'Oracle');
INSERT INTO `fldvalue` VALUES (181, '99', 'sysds', 'type', 2, 'MySql', 'MySql', 'MySql');
INSERT INTO `fldvalue` VALUES (182, '99', 'sysds', 'type', 3, 'PostgreSQL', 'PostgreSQL', 'PostgreSQL');
INSERT INTO `fldvalue` VALUES (183, '99', 'sysds', 'type', 4, 'SqlServer', 'SqlServer', 'SqlServer');
INSERT INTO `fldvalue` VALUES (378, '0', 'procassi', 'sel', 1, 'group', '组', '');
INSERT INTO `fldvalue` VALUES (379, '0', 'procassi', 'sel', 2, 'deppos', '部门+职位', '');
INSERT INTO `fldvalue` VALUES (538, '0', 'cl_snjt', 'trfct', 1, '出租车', '出租车', '');
INSERT INTO `fldvalue` VALUES (539, '0', 'cl_snjt', 'trfct', 2, '地铁', '地铁', '');
INSERT INTO `fldvalue` VALUES (540, '0', 'cl_snjt', 'trfct', 3, '公交', '公交', '');
INSERT INTO `fldvalue` VALUES (650, '0', 'delegate', 'name', 1, 'BS', 'plugin:SelOrganUser,field:name,#{assignee}:no', '');
INSERT INTO `fldvalue` VALUES (651, '0', 'delegate', 'procname', 1, 'BS', 'func:cx.bpm.bpm.getProcsAll(),params:,field:namec,fieldDisp:namec,#{prockey}:prockey', '');
INSERT INTO `fldvalue` VALUES (652, '0', 'delegate', 'inuse', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (653, '0', 'delegate', 'inuse', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (744, '0', 'sysroleobj', 'type', 1, '1', '功能权限', 'func');
INSERT INTO `fldvalue` VALUES (745, '0', 'sysroleobj', 'type', 2, '2', '按钮权限', 'btn');
INSERT INTO `fldvalue` VALUES (746, '0', 'sysroleobj', 'type', 3, '3', '图层权限', 'layer');
INSERT INTO `fldvalue` VALUES (747, '0', 'sysroleobj', 'type', 4, '4', '区域查看', 'region');
INSERT INTO `fldvalue` VALUES (748, '0', 'sysroleobj', 'type', 5, '5', '实体查看', 'ettCatView');
INSERT INTO `fldvalue` VALUES (749, '0', 'sysroleobj', 'type', 6, '6', '实体编辑', 'ettCatEdit');
INSERT INTO `fldvalue` VALUES (750, '0', 'sysroleobj', 'type', 7, '7', '部门权限', 'organ');
INSERT INTO `fldvalue` VALUES (751, '0', 'userdep', 'userid', 1, 'BS', 'plugin:SelOrganUser,field:id,fieldDisp:no', 'BS');
INSERT INTO `fldvalue` VALUES (752, '0', 'userdep', 'organid', 1, 'BS', 'plugin:SelOrgan,field:id,fieldDisp:namec', 'BS');
INSERT INTO `fldvalue` VALUES (753, '0', 'userdep', 'organname', 1, 'BS', 'plugin:SelOrganPerm,field:namec,#{organid}:id', 'BS');
INSERT INTO `fldvalue` VALUES (754, '0', 'userdep', 'username', 1, 'BS', 'plugin:SelOrganUserPerm,field:name,#{userid}:id', 'BS');
INSERT INTO `fldvalue` VALUES (755, '0', 'userdep', 'position', 1, '员工', '员工', '员工');
INSERT INTO `fldvalue` VALUES (756, '0', 'userdep', 'position', 2, '副组长', '副组长', '副组长');
INSERT INTO `fldvalue` VALUES (757, '0', 'userdep', 'position', 3, '组长', '组长', '组长');
INSERT INTO `fldvalue` VALUES (758, '0', 'userdep', 'position', 4, '副经理', '副经理', '副经理');
INSERT INTO `fldvalue` VALUES (759, '0', 'userdep', 'position', 5, '经理', '经理', '经理');
INSERT INTO `fldvalue` VALUES (760, '0', 'userdep', 'position', 6, '副总经理', '副总经理', '副总经理');
INSERT INTO `fldvalue` VALUES (761, '0', 'userdep', 'position', 7, '总经理', '总经理', '总经理');
INSERT INTO `fldvalue` VALUES (762, '0', 'userdep', 'position', 8, '董事长', '董事长', '董事长');
INSERT INTO `fldvalue` VALUES (763, '0', 'sysrole', 'type', 1, '1', '角色', 'Role');
INSERT INTO `fldvalue` VALUES (764, '0', 'sysrole', 'type', 2, '0', '角色组', 'Role Group');
INSERT INTO `fldvalue` VALUES (869, '0', 'hr_punc', 'wdk', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1021, '0', 'oa_prjwh', 'prj', 1, 'BS', 'func:oa.api.getMyPrj,params:,field:name,#{prjid}:id', '');
INSERT INTO `fldvalue` VALUES (1364, '0', 'procs', 'hastask', 1, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1365, '0', 'procs', 'hastask', 2, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1366, '0', 'procs', 'attach', 1, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1367, '0', 'procs', 'attach', 2, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1368, '0', 'procs', 'hascomp', 1, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1369, '0', 'procs', 'hascomp', 2, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1509, '0', 'user1', 'no', 1, 'BS', 'func:cx.svr.bpm.getBillM,field:bill,params:GH', '');
INSERT INTO `fldvalue` VALUES (1510, '0', 'oa_asset', 'no', 1, 'BS', 'func:cx.svr.bpm.getBillM,field:bill,params:ZC', '');
INSERT INTO `fldvalue` VALUES (1511, '0', 'oa_asset', 'hgr', 1, 'BS', 'plugin:SelOrganUser,field:name,#{hgrid}:id', '');
INSERT INTO `fldvalue` VALUES (1512, '0', 'oa_asset', 'type', 1, '台式电脑', '台式电脑', '');
INSERT INTO `fldvalue` VALUES (1513, '0', 'oa_asset', 'type', 2, '合购笔记本', '合购笔记本', '');
INSERT INTO `fldvalue` VALUES (1514, '0', 'oa_asset', 'type', 3, '笔记本电脑', '笔记本电脑', '');
INSERT INTO `fldvalue` VALUES (1515, '0', 'oa_asset', 'type', 4, '服务器', '服务器', '');
INSERT INTO `fldvalue` VALUES (1516, '0', 'oa_asset', 'type', 5, '主机', '主机', '');
INSERT INTO `fldvalue` VALUES (1517, '0', 'oa_asset', 'type', 6, '打印机', '打印机', '');
INSERT INTO `fldvalue` VALUES (1518, '0', 'oa_asset', 'type', 7, '软件', '软件', '');
INSERT INTO `fldvalue` VALUES (1519, '0', 'oa_asset', 'type', 8, '其他', '其他', '');
INSERT INTO `fldvalue` VALUES (1520, '0', 'oa_asset', 'secret', 1, '无密级', '无密级', '');
INSERT INTO `fldvalue` VALUES (1521, '0', 'oa_asset', 'secret', 2, '涉密', '涉密', '');
INSERT INTO `fldvalue` VALUES (1522, '0', 'oa_giftuse', 'name', 1, 'BS', 'plugin:SelOrganUser,field:name,#{userid}:id', '');
INSERT INTO `fldvalue` VALUES (1523, '0', 'oa_giftd', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1524, '0', 'oa_giftd', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1525, '0', 'oa_giftd', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1526, '0', 'oa_giftd', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1527, '0', 'oa_bjbdn', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1528, '0', 'oa_bjbdn', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1529, '0', 'oa_bjbdn', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1530, '0', 'oa_bjbdn', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1533, '0', 'oa_customer', 'province', 1, 'BS', 'func:oa.api.getProvince(),params:,field:name', '');
INSERT INTO `fldvalue` VALUES (1534, '0', 'oa_customer', 'city', 1, 'BS', 'func:oa.api.getCity(),params:#{province},field:name', '');
INSERT INTO `fldvalue` VALUES (1535, '0', 'oa_prj', 'no', 1, 'BS', 'func:cx.svr.bpm.getBillM,field:bill,params:XM', '');
INSERT INTO `fldvalue` VALUES (1536, '0', 'oa_prj', 'depart', 1, 'BS', 'plugin:SelOrgan,field:namec', '');
INSERT INTO `fldvalue` VALUES (1537, '0', 'oa_prj', 'ht', 1, 'BS', 'plugin:SelHt,field:name,#{htid}:id,#{custid}:custid,#{cust}:cust', '');
INSERT INTO `fldvalue` VALUES (1538, '0', 'oa_prj', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1539, '0', 'oa_prj', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1540, '0', 'oa_prj', 'phase', 1, 'Demo', 'Demo', '');
INSERT INTO `fldvalue` VALUES (1541, '0', 'oa_prj', 'phase', 2, '设计', '设计', '');
INSERT INTO `fldvalue` VALUES (1542, '0', 'oa_prj', 'phase', 3, '开发', '开发', '');
INSERT INTO `fldvalue` VALUES (1543, '0', 'oa_prj', 'phase', 4, '初验', '初验', '');
INSERT INTO `fldvalue` VALUES (1544, '0', 'oa_prj', 'phase', 5, '试运行', '试运行', '');
INSERT INTO `fldvalue` VALUES (1545, '0', 'oa_prj', 'phase', 6, '终验', '终验', '');
INSERT INTO `fldvalue` VALUES (1546, '0', 'oa_prj', 'phase', 7, '维护', '维护', '');
INSERT INTO `fldvalue` VALUES (1547, '0', 'oa_prjmem', 'username', 1, 'BS', 'plugin:SelOrganUser,field:name,#{userid}:id', '');
INSERT INTO `fldvalue` VALUES (1548, '0', 'oa_prjmem', 'rol', 1, '项目成员', '项目成员', '');
INSERT INTO `fldvalue` VALUES (1549, '0', 'oa_prjmem', 'rol', 2, '项目经理', '项目经理', '');
INSERT INTO `fldvalue` VALUES (1550, '0', 'oa_prjmem', 'rol', 3, '技术负责人', '技术负责人', '');
INSERT INTO `fldvalue` VALUES (1551, '0', 'oa_prjmem', 'rol', 4, '项目助理', '项目助理', '');
INSERT INTO `fldvalue` VALUES (1552, '0', 'oa_prjms', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1553, '0', 'oa_prjms', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1554, '0', 'oa_prjms', 'level', 1, '5', '5', '');
INSERT INTO `fldvalue` VALUES (1555, '0', 'oa_prjms', 'level', 2, '4', '4', '');
INSERT INTO `fldvalue` VALUES (1556, '0', 'oa_prjms', 'level', 3, '3', '3', '');
INSERT INTO `fldvalue` VALUES (1557, '0', 'oa_prjms', 'level', 4, '2', '2', '');
INSERT INTO `fldvalue` VALUES (1558, '0', 'oa_prjms', 'level', 5, '1', '1', '');
INSERT INTO `fldvalue` VALUES (1559, '0', 'oa_prjprob', 'name', 1, 'BS', 'plugin:SelOrganUser,field:name,#{userid}:id', '');
INSERT INTO `fldvalue` VALUES (1560, '0', 'oa_prjprob', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1561, '0', 'oa_prjprob', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1562, '0', 'oa_prjprob', 'resolved', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1563, '0', 'oa_prjprob', 'resolved', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1564, '0', 'oa_prjprob', 'level', 1, '5', '5', '');
INSERT INTO `fldvalue` VALUES (1565, '0', 'oa_prjprob', 'level', 2, '4', '4', '');
INSERT INTO `fldvalue` VALUES (1566, '0', 'oa_prjprob', 'level', 3, '3', '3', '');
INSERT INTO `fldvalue` VALUES (1567, '0', 'oa_prjprob', 'level', 4, '2', '2', '');
INSERT INTO `fldvalue` VALUES (1568, '0', 'oa_prjprob', 'level', 5, '1', '1', '');
INSERT INTO `fldvalue` VALUES (1569, '0', 'oa_prjtask', 'name', 1, 'BS', 'func:oa.api.getPrjMem,params:#{id0},field:username,#{userid}:userid', '');
INSERT INTO `fldvalue` VALUES (1570, '0', 'oa_prjtask', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1571, '0', 'oa_prjtask', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1572, '0', 'oa_prjtask', 'resolved', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1573, '0', 'oa_prjtask', 'resolved', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1574, '0', 'oa_prjtask', 'level', 1, '5', '5', '');
INSERT INTO `fldvalue` VALUES (1575, '0', 'oa_prjtask', 'level', 2, '4', '4', '');
INSERT INTO `fldvalue` VALUES (1576, '0', 'oa_prjtask', 'level', 3, '3', '3', '');
INSERT INTO `fldvalue` VALUES (1577, '0', 'oa_prjtask', 'level', 4, '2', '2', '');
INSERT INTO `fldvalue` VALUES (1578, '0', 'oa_prjtask', 'level', 5, '1', '1', '');
INSERT INTO `fldvalue` VALUES (1579, '0', 'oa_prjtime', 'prj', 1, 'BS', 'func:oa.api.getMyPrj,params:,field:name,#{prjid}:id', '');
INSERT INTO `fldvalue` VALUES (1580, '0', 'ht_info', 'no', 1, 'BS', 'func:cx.svr.bpm.getBillM,field:bill,params:HT', '');
INSERT INTO `fldvalue` VALUES (1581, '0', 'ht_info', 'cust', 1, 'BS', 'plugin:SelCustomer,field:name,#{custid}:id', '');
INSERT INTO `fldvalue` VALUES (1582, '0', 'ht_info', 'prj', 1, 'BS', 'plugin:SelPrj,field:name,#{prjid}:id', '');
INSERT INTO `fldvalue` VALUES (1583, '0', 'ht_info', 'pz', 1, '专票', '专票', '');
INSERT INTO `fldvalue` VALUES (1584, '0', 'ht_info', 'pz', 2, '普票', '普票', '');
INSERT INTO `fldvalue` VALUES (1585, '0', 'ht_info', 'sl', 1, '6%', '6%', '');
INSERT INTO `fldvalue` VALUES (1586, '0', 'ht_info', 'sl', 2, '0%', '0%', '');
INSERT INTO `fldvalue` VALUES (1587, '0', 'ht_info', 'sfyshd', 1, '0', '没有', '');
INSERT INTO `fldvalue` VALUES (1588, '0', 'ht_info', 'sfyshd', 2, '1', '有', '');
INSERT INTO `fldvalue` VALUES (1589, '0', 'ht_info', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1590, '0', 'ht_info', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1591, '0', 'f_ddbxd', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1592, '0', 'f_ddbxd', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1593, '0', 'f_ddbxd', 'dep', 1, 'BS', 'plugin:SelOrgan,field:namec', '');
INSERT INTO `fldvalue` VALUES (1594, '0', 'f_ddbxd', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1595, '0', 'f_ddbxd', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1596, '0', 'hr_leave', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1597, '0', 'hr_leave', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1598, '0', 'hr_leave', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1599, '0', 'hr_leave', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1600, '0', 'hr_leave', 'type', 1, '1', '事假', '');
INSERT INTO `fldvalue` VALUES (1601, '0', 'hr_leave', 'type', 2, '2', '病假', '');
INSERT INTO `fldvalue` VALUES (1602, '0', 'hr_leave', 'type', 3, '0', '年假', '');
INSERT INTO `fldvalue` VALUES (1603, '0', 'hr_leave', 'type', 4, '3', '婚假', '');
INSERT INTO `fldvalue` VALUES (1604, '0', 'hr_leave', 'type', 5, '4', '产假', '');
INSERT INTO `fldvalue` VALUES (1605, '0', 'hr_leave', 'type', 6, '5', '丧假', '');
INSERT INTO `fldvalue` VALUES (1606, '0', 'hr_bustrip', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1607, '0', 'hr_bustrip', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1608, '0', 'hr_bustrip', 'prj', 1, 'BS', 'plugin:SelMyPrj,field:name,params:,#{prjid}:id', '');
INSERT INTO `fldvalue` VALUES (1609, '0', 'hr_bustrip', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1610, '0', 'hr_bustrip', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1611, '0', 'hr_out', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1612, '0', 'hr_out', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1613, '0', 'hr_out', 'prj', 1, 'BS', 'plugin:SelMyPrj,field:name,params:,#{prjid}:id', '');
INSERT INTO `fldvalue` VALUES (1614, '0', 'hr_out', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1615, '0', 'hr_out', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1616, '0', 'hr_out', 'zdk', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1617, '0', 'hr_out', 'zdk', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1618, '0', 'hr_out', 'wdk', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1619, '0', 'hr_out', 'wdk', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1620, '0', 'hr_punch', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1621, '0', 'hr_punch', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1622, '0', 'hr_punch', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1623, '0', 'hr_punch', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1624, '0', 'hr_punch', 'zdk', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1625, '0', 'hr_punch', 'zdk', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1626, '0', 'hr_punch', 'wdk', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1627, '0', 'hr_punch', 'wdk', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1628, '0', 'wm_meet', 'depart', 1, 'BS', 'plugin:SelOrgan,field:namec', '');
INSERT INTO `fldvalue` VALUES (1629, '0', 'wm_meetmem', 'name', 1, 'BS', 'plugin:SelOrganUser,field:name,#{userid}:id', '');
INSERT INTO `fldvalue` VALUES (1630, '0', 'wm_meetrec', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1631, '0', 'wm_meetrec', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1632, '0', 'oa_seal', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1633, '0', 'oa_seal', 'type', 1, '0', '商务类', '');
INSERT INTO `fldvalue` VALUES (1634, '0', 'oa_seal', 'type', 2, '1', '财务类', '');
INSERT INTO `fldvalue` VALUES (1635, '0', 'oa_seal', 'type', 3, '2', '人力类', '');
INSERT INTO `fldvalue` VALUES (1636, '0', 'oa_seal', 'type', 4, '3', '行政类', '');
INSERT INTO `fldvalue` VALUES (1637, '0', 'oa_seal', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1638, '0', 'oa_seal', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1639, '0', 'oa_htps', 'depart', 1, 'BS', 'select:department,field:namec', '');
INSERT INTO `fldvalue` VALUES (1640, '0', 'oa_htps', 'position', 1, 'BS', 'select:position', '');
INSERT INTO `fldvalue` VALUES (1641, '0', 'oa_htps', 'type', 1, '销售合同', '销售合同', '');
INSERT INTO `fldvalue` VALUES (1642, '0', 'oa_htps', 'type', 2, '采购合同', '采购合同', '');
INSERT INTO `fldvalue` VALUES (1643, '0', 'oa_htps', 'type', 3, '合作协议', '合作协议', '');
INSERT INTO `fldvalue` VALUES (1644, '0', 'oa_htps', 'completed', 1, '1', '是', '');
INSERT INTO `fldvalue` VALUES (1645, '0', 'oa_htps', 'completed', 2, '0', '否', '');
INSERT INTO `fldvalue` VALUES (1646, '0', 'hr_clockin', 'type', 1, '0', '早打卡', '');
INSERT INTO `fldvalue` VALUES (1647, '0', 'hr_clockin', 'type', 2, '1', '晚打卡', '');
INSERT INTO `fldvalue` VALUES (1648, '0', 'types', 'type', 1, '1', '综合知识', '');
INSERT INTO `fldvalue` VALUES (1651, '0', 'types', 'type', 2, '2', '案列分析', '');
INSERT INTO `fldvalue` VALUES (1652, '0', 'types', 'type', 3, '3', '论文写作', '');
INSERT INTO `fldvalue` VALUES (1653, '0', 'types', 'type', 4, '4', '知识考点', '');
INSERT INTO `fldvalue` VALUES (1658, '0', 'shop', 'type', 1, '1', '精品团购', 'Boutique Group Buying');
INSERT INTO `fldvalue` VALUES (1659, '0', 'shop', 'type', 2, '2', '分类精选', 'Competitive Products For You');
INSERT INTO `fldvalue` VALUES (1660, '0', 'shop', 'type', 3, '3', '猜你喜欢', 'Guess You Like It');
INSERT INTO `fldvalue` VALUES (1661, '0', 'cat', 'type', 0, '1', '默认', '');
INSERT INTO `fldvalue` VALUES (1662, '0', 'cat', 'type', 1, '2', '分类', '');
INSERT INTO `fldvalue` VALUES (1663, '0', 'shopcart', 'state', 1, '1', '删除', '');
INSERT INTO `fldvalue` VALUES (1664, '0', 'shopcart', 'state', 1, '0', '恢复删除', '');
COMMIT;

-- ----------------------------
-- Table structure for history
-- ----------------------------
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `state` int(11) DEFAULT NULL,
  `time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of history
-- ----------------------------
BEGIN;
INSERT INTO `history` VALUES (1, 1, 1, 0, '2020-03-11 20:35:18');
COMMIT;

-- ----------------------------
-- Table structure for lin
-- ----------------------------
DROP TABLE IF EXISTS `lin`;
CREATE TABLE `lin` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `coor` tinyblob,
  `dir` int(11) DEFAULT NULL,
  `dotn` int(11) DEFAULT NULL,
  `fntid` int(11) DEFAULT NULL,
  `geometry` varchar(255) DEFAULT NULL,
  `gl` int(11) DEFAULT NULL,
  `h` float DEFAULT NULL,
  `layer` int(11) DEFAULT NULL,
  `len` float DEFAULT NULL,
  `lockid` int(11) DEFAULT NULL,
  `locktime` datetime DEFAULT NULL,
  `map` int(11) DEFAULT NULL,
  `minor` int(11) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `prj` int(11) DEFAULT NULL,
  `reg` int(11) DEFAULT NULL,
  `st` int(11) DEFAULT NULL,
  `talid` int(11) DEFAULT NULL,
  `timelen` float DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `w` float DEFAULT NULL,
  `z` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for media
-- ----------------------------
DROP TABLE IF EXISTS `media`;
CREATE TABLE `media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `major` decimal(5,0) NOT NULL,
  `minor` decimal(5,0) NOT NULL,
  `entityid` decimal(9,0) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `title` varchar(64) DEFAULT NULL,
  `uperson` varchar(32) NOT NULL,
  `udate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `filelength` decimal(9,0) NOT NULL DEFAULT '0',
  `files` longblob,
  `bz` varchar(128) DEFAULT NULL,
  `fid` decimal(9,0) NOT NULL DEFAULT '0',
  `sys` decimal(5,0) NOT NULL DEFAULT '0',
  `glid` int(11) NOT NULL DEFAULT '0',
  `task` varchar(32) NOT NULL,
  `bustype` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_en` (`major`,`minor`,`entityid`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of media
-- ----------------------------
BEGIN;
INSERT INTO `media` VALUES (150, 97, 2, 1, 'https://gd3.alicdn.com/imgextra/i4/479184430/O1CN01nCpuLc1iaz4bcSN17_!!479184430.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知-张艺0422.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '2');
INSERT INTO `media` VALUES (151, 97, 2, 1, 'https://gd2.alicdn.com/imgextra/i2/479184430/O1CN01gwbN931iaz4TzqzmG_!!479184430.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知-张艺0422.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '2');
INSERT INTO `media` VALUES (152, 97, 2, 1, 'https://gd3.alicdn.com/imgextra/i3/479184430/O1CN018wVjQh1iaz4aupv1A_!!479184430.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知-张艺0422.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '2');
INSERT INTO `media` VALUES (153, 97, 2, 1, 'https://gd4.alicdn.com/imgextra/i4/479184430/O1CN01tWg4Us1iaz4auqelt_!!479184430.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知-张艺0422.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '2');
INSERT INTO `media` VALUES (154, 97, 2, 1, 'https://gd1.alicdn.com/imgextra/i1/479184430/O1CN01Tnm1rU1iaz4aVKcwP_!!479184430.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知-张艺0422.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '2');
INSERT INTO `media` VALUES (155, 97, 2, 1, 'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=1618309945,4014036594&fm=26&gp=0.jpg', '关于公司新OA系统上线试运行的0422.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '1');
INSERT INTO `media` VALUES (156, 97, 2, 1, 'https://gd3.alicdn.com/imgextra/i3/TB1RPFPPFXXXXcNXpXXXXXXXXXX_!!0-item_pic.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '1');
INSERT INTO `media` VALUES (157, 97, 2, 1, 'https://gd2.alicdn.com/imgextra/i2/38832490/O1CN01IYq7gu1UGShvbEFnd_!!38832490.jpg_400x400.jpg', '关于公司新OA系统上线试运行的通知.docx', 'zcj', '2019-04-22 11:27:55', 18944, NULL, NULL, 0, 21, 0, '图文详情', '1');
INSERT INTO `media` VALUES (158, 0, 0, 1, '/static/temp/banner3.jpg', NULL, '首页banner', '2020-03-09 17:09:24', 0, NULL, NULL, 0, 0, 0, '第一张', NULL);
INSERT INTO `media` VALUES (159, 0, 0, 1, '/static/temp/banner2.jpg', NULL, '首页banner', '2020-03-09 17:09:24', 0, NULL, NULL, 0, 0, 0, '第一张', NULL);
INSERT INTO `media` VALUES (160, 0, 0, 1, '/static/temp/banner4.jpg', NULL, '首页banner', '2020-03-09 17:09:24', 0, NULL, NULL, 0, 0, 0, '第一张', NULL);
INSERT INTO `media` VALUES (161, 0, 0, 2, '/static/temp/ad1.jpg', NULL, '首页下面的banner', '2020-03-09 17:09:24', 0, NULL, NULL, 0, 0, 0, '首页下面的banner', NULL);
COMMIT;

-- ----------------------------
-- Table structure for orderinfo
-- ----------------------------
DROP TABLE IF EXISTS `orderinfo`;
CREATE TABLE `orderinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopid` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `consigneename` varchar(255) NOT NULL,
  `consigneemobile` varchar(255) NOT NULL,
  `provincecityarea` varchar(255) NOT NULL,
  `consigneeaddress` varchar(255) DEFAULT NULL,
  `orderno` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `userid` int(11) NOT NULL,
  `nums` int(11) NOT NULL,
  `size` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of orderinfo
-- ----------------------------
BEGIN;
INSERT INTO `orderinfo` VALUES (1, 1, 264.00, '许小星', '13853989563', '山东省济南市历城区', '149号', 1, 1, '2020-03-16 19:26:32', 1, 1, 'M', '蓝色');
INSERT INTO `orderinfo` VALUES (2, 1, 264.00, '许小星', '13853989563', '山东省济南市历城区', '149号', 1, 1, '2020-03-16 19:26:32', 1, 1, 'M', '蓝色');
INSERT INTO `orderinfo` VALUES (3, 1, 264.00, '许小星', '13853989563', '山东省济南市历城区', '149号', 1, 1, '2020-03-16 19:26:33', 1, 1, 'M', '蓝色');
INSERT INTO `orderinfo` VALUES (4, 1, 264.00, '许小星', '13853989563', '山东省济南市历城区', '149号', 1, 1, '2020-03-16 19:26:33', 1, 1, 'M', '蓝色');
INSERT INTO `orderinfo` VALUES (5, 1, 264.00, '许小星', '13853989563', '山东省济南市历城区', '149号', 1, 1, '2020-03-16 19:26:34', 1, 1, 'M', '蓝色');
COMMIT;

-- ----------------------------
-- Table structure for pnt
-- ----------------------------
DROP TABLE IF EXISTS `pnt`;
CREATE TABLE `pnt` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ang` float DEFAULT NULL,
  `coor` tinyblob,
  `geometry` varchar(255) DEFAULT NULL,
  `gl` int(11) DEFAULT NULL,
  `h` float DEFAULT NULL,
  `layer` int(11) DEFAULT NULL,
  `lockid` int(11) DEFAULT NULL,
  `map` int(11) DEFAULT NULL,
  `minor` int(11) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `prj` int(11) DEFAULT NULL,
  `reg` int(11) DEFAULT NULL,
  `st` int(11) DEFAULT NULL,
  `timelen` int(11) DEFAULT NULL,
  `w` float DEFAULT NULL,
  `z` varchar(255) DEFAULT NULL,
  `ztid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for pol
-- ----------------------------
DROP TABLE IF EXISTS `pol`;
CREATE TABLE `pol` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ang` float DEFAULT NULL,
  `coor` tinyblob,
  `geometry` varchar(255) DEFAULT NULL,
  `gl` int(11) DEFAULT NULL,
  `h` float DEFAULT NULL,
  `layer` int(11) DEFAULT NULL,
  `lockid` int(11) DEFAULT NULL,
  `map` int(11) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `prj` int(11) DEFAULT NULL,
  `reg` int(11) DEFAULT NULL,
  `st` int(11) DEFAULT NULL,
  `timelen` int(11) DEFAULT NULL,
  `w` float DEFAULT NULL,
  `z` varchar(255) DEFAULT NULL,
  `ztid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for seckill
-- ----------------------------
DROP TABLE IF EXISTS `seckill`;
CREATE TABLE `seckill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `oldprice` decimal(10,2) DEFAULT NULL,
  `xl` varchar(255) NOT NULL,
  `kc` varchar(255) NOT NULL,
  `liull` varchar(355) DEFAULT NULL,
  `size` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `yhj` varchar(555) DEFAULT NULL,
  `zx` varchar(255) DEFAULT NULL,
  `fw` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `bg` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `tg` decimal(10,0) DEFAULT NULL,
  `shopname` varchar(255) NOT NULL,
  `shopimg` varchar(255) DEFAULT NULL,
  `cxje` decimal(10,0) NOT NULL,
  `kdfy` decimal(10,0) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of seckill
-- ----------------------------
BEGIN;
INSERT INTO `seckill` VALUES (1, '古黛妃 短袖t恤女夏装2019新款韩版宽松', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '1', '1', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553187020783&di=bac9dd78b36fd984502d404d231011c0&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201609%2F26%2F20160926173213_s5adi.jpeg', 6, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (2, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '1', '1', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1554013048&di=a3dc9fd1406dd7bad7fbb97b5489ec04&imgtype=jpg&er=1&src=http%3A%2F%2Fimg009.hc360.cn%2Fhb%2FnKo44ac2656F831c684507E3Da0E3a26841.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (3, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '2', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409398864&di=4a12763adccf229133fb85193b7cc08f&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201703%2F19%2F20170319150032_MNwmn.jpeg', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1554013048&di=a3dc9fd1406dd7bad7fbb97b5489ec04&imgtype=jpg&er=1&src=http%3A%2F%2Fimg009.hc360.cn%2Fhb%2FnKo44ac2656F831c684507E3Da0E3a26841.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (4, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '2', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409398864&di=4a12763adccf229133fb85193b7cc08f&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201703%2F19%2F20170319150032_MNwmn.jpeg', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553187020783&di=bac9dd78b36fd984502d404d231011c0&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201609%2F26%2F20160926173213_s5adi.jpeg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (5, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '3', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409984228&di=dee176242038c2d545b7690b303d65ea&imgtype=0&src=http%3A%2F%2Fhbimg.b0.upaiyun.com%2F5ef4da9f17faaf4612f0d5046f4161e556e9bbcfdb5b-rHjf00_fw658', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553418265666&di=d4a7f7eb0ae3c859edeb921641ee1c3a&imgtype=0&src=http%3A%2F%2Fimg003.hc360.cn%2Fy3%2FM02%2FF8%2F9F%2FwKhQh1TuSkGELIlQAAAAAPuLl4M987.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (6, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '3', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409984228&di=dee176242038c2d545b7690b303d65ea&imgtype=0&src=http%3A%2F%2Fhbimg.b0.upaiyun.com%2F5ef4da9f17faaf4612f0d5046f4161e556e9bbcfdb5b-rHjf00_fw658', 'https://img13.360buyimg.com/n8/jfs/t1/30343/20/1029/481370/5c449438Ecb46a15b/2b2adccb6dc742fd.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (7, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '4', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409794730&di=12b840ec4f5748ef06880b85ff63e34e&imgtype=0&src=http%3A%2F%2Fimg.zcool.cn%2Fcommunity%2F01dc03589ed568a8012060c82ac03c.jpg%40900w_1l_2o_100sh.jpg', 'http://images.jaadee.com/images/201702/goods_img/30150_d85aed83521.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (8, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '4', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409794730&di=12b840ec4f5748ef06880b85ff63e34e&imgtype=0&src=http%3A%2F%2Fimg.zcool.cn%2Fcommunity%2F01dc03589ed568a8012060c82ac03c.jpg%40900w_1l_2o_100sh.jpg', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=1620020012,789258862&fm=26&gp=0.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (9, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '5', '1', 'http://m.360buyimg.com/n12/jfs/t247/42/1078640382/162559/3628a0b/53f5ad09N0dd79894.jpg%21q70.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `seckill` VALUES (10, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '5', '1', 'http://img.zcool.cn/community/017a4e58b4eab6a801219c77084373.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `oldprice` decimal(10,2) DEFAULT NULL,
  `xl` varchar(255) NOT NULL,
  `kc` varchar(255) NOT NULL,
  `liull` varchar(355) DEFAULT NULL,
  `size` varchar(255) NOT NULL,
  `color` varchar(255) NOT NULL,
  `yhj` varchar(555) DEFAULT NULL,
  `zx` varchar(255) DEFAULT NULL,
  `fw` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `bg` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `tg` decimal(10,0) DEFAULT NULL,
  `shopname` varchar(255) NOT NULL,
  `shopimg` varchar(255) DEFAULT NULL,
  `cxje` decimal(10,0) NOT NULL,
  `kdfy` decimal(10,0) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shop
-- ----------------------------
BEGIN;
INSERT INTO `shop` VALUES (1, '古黛妃 短袖t恤女夏装2019新款韩版宽松', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '1', '1', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553187020783&di=bac9dd78b36fd984502d404d231011c0&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201609%2F26%2F20160926173213_s5adi.jpeg', 6, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (2, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '1', '1', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1554013048&di=a3dc9fd1406dd7bad7fbb97b5489ec04&imgtype=jpg&er=1&src=http%3A%2F%2Fimg009.hc360.cn%2Fhb%2FnKo44ac2656F831c684507E3Da0E3a26841.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (3, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '2', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409398864&di=4a12763adccf229133fb85193b7cc08f&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201703%2F19%2F20170319150032_MNwmn.jpeg', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1554013048&di=a3dc9fd1406dd7bad7fbb97b5489ec04&imgtype=jpg&er=1&src=http%3A%2F%2Fimg009.hc360.cn%2Fhb%2FnKo44ac2656F831c684507E3Da0E3a26841.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (4, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '2', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409398864&di=4a12763adccf229133fb85193b7cc08f&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201703%2F19%2F20170319150032_MNwmn.jpeg', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553187020783&di=bac9dd78b36fd984502d404d231011c0&imgtype=0&src=http%3A%2F%2Fb-ssl.duitang.com%2Fuploads%2Fitem%2F201609%2F26%2F20160926173213_s5adi.jpeg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (5, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '3', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409984228&di=dee176242038c2d545b7690b303d65ea&imgtype=0&src=http%3A%2F%2Fhbimg.b0.upaiyun.com%2F5ef4da9f17faaf4612f0d5046f4161e556e9bbcfdb5b-rHjf00_fw658', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553418265666&di=d4a7f7eb0ae3c859edeb921641ee1c3a&imgtype=0&src=http%3A%2F%2Fimg003.hc360.cn%2Fy3%2FM02%2FF8%2F9F%2FwKhQh1TuSkGELIlQAAAAAPuLl4M987.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (6, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '3', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409984228&di=dee176242038c2d545b7690b303d65ea&imgtype=0&src=http%3A%2F%2Fhbimg.b0.upaiyun.com%2F5ef4da9f17faaf4612f0d5046f4161e556e9bbcfdb5b-rHjf00_fw658', 'https://img13.360buyimg.com/n8/jfs/t1/30343/20/1029/481370/5c449438Ecb46a15b/2b2adccb6dc742fd.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (7, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '4', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409794730&di=12b840ec4f5748ef06880b85ff63e34e&imgtype=0&src=http%3A%2F%2Fimg.zcool.cn%2Fcommunity%2F01dc03589ed568a8012060c82ac03c.jpg%40900w_1l_2o_100sh.jpg', 'http://images.jaadee.com/images/201702/goods_img/30150_d85aed83521.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (8, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '4', 'https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1553409794730&di=12b840ec4f5748ef06880b85ff63e34e&imgtype=0&src=http%3A%2F%2Fimg.zcool.cn%2Fcommunity%2F01dc03589ed568a8012060c82ac03c.jpg%40900w_1l_2o_100sh.jpg', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=1620020012,789258862&fm=26&gp=0.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (9, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '5', '1', 'http://m.360buyimg.com/n12/jfs/t247/42/1078640382/162559/3628a0b/53f5ad09N0dd79894.jpg%21q70.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
INSERT INTO `shop` VALUES (10, '潘歌针织连衣裙', 265.00, 345.00, '100', '300', '200', '[{\"id\":1,\"pid\":1,\"name\":\"XS\"},{\"id\":2,\"pid\":1,\"name\":\"S\"},{\"id\":3,\"pid\":1,\"name\":\"M\"},{\"id\":4,\"pid\":1,\"name\":\"L\"},{\"id\":5,\"pid\":1,\"name\":\"XL\"},{\"id\":6,\"pid\":1,\"name\":\"XXL\"}]', '[{\"id\":7,\"pid\":2,\"name\":\"白色\"},{\"id\":8,\"pid\":2,\"name\":\"珊瑚粉\"},{\"id\":9,\"pid\":2,\"name\":\"草木绿\"}]', '[{\"title\":\"新用户专享优惠券\",\"price\":5,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"庆五一发一波优惠券\",\"price\":10,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30},{\"title\":\"优惠券优惠券优惠券优惠券\",\"price\":15,\"time\":\"2019-06-30\",\"xz\":\"限新用户使用\",\"jexz\":30}]', '新人首单送20元无门槛代金券,订单满50减10,订单满100减30,单笔购买满两件免邮费', '7天无理由退换货 ·,假一赔十 ·', '5', '1', 'http://img.zcool.cn/community/017a4e58b4eab6a801219c77084373.jpg', 10, '西城小铺', 'http://img0.imgtn.bdimg.com/it/u=2971348996,3395851350&fm=26&gp=0.jpg', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for shopcart
-- ----------------------------
DROP TABLE IF EXISTS `shopcart`;
CREATE TABLE `shopcart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `nums` int(11) NOT NULL,
  `state` int(11) NOT NULL,
  `time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  `sizecolor` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shopcart
-- ----------------------------
BEGIN;
INSERT INTO `shopcart` VALUES (1, 1, 1, 1, 0, '2020-03-10 21:32:16', 'M 白色');
COMMIT;

-- ----------------------------
-- Table structure for syscache
-- ----------------------------
DROP TABLE IF EXISTS `syscache`;
CREATE TABLE `syscache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tabname` varchar(32) NOT NULL,
  `usesys` decimal(1,0) NOT NULL,
  `exp` varchar(64) NOT NULL,
  `classname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `syscache_tab` (`tabname`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of syscache
-- ----------------------------
BEGIN;
INSERT INTO `syscache` VALUES (5, 'syscfg', 0, 'id>=0', NULL);
INSERT INTO `syscache` VALUES (6, 'entity', 0, 'id>=0', NULL);
INSERT INTO `syscache` VALUES (7, 'fld', 1, 'id>=0', NULL);
INSERT INTO `syscache` VALUES (8, 'fldvalue', 1, 'id>=0', NULL);
INSERT INTO `syscache` VALUES (33, 'cate', 1, 'id>=0', NULL);
COMMIT;

-- ----------------------------
-- Table structure for syscfg
-- ----------------------------
DROP TABLE IF EXISTS `syscfg`;
CREATE TABLE `syscfg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `keyno` varchar(32) NOT NULL,
  `namee` varchar(32) DEFAULT NULL,
  `namec` varchar(32) DEFAULT NULL,
  `value` varchar(1024) NOT NULL,
  `memo` varchar(256) DEFAULT NULL,
  `isfilter` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `syscfg_keyno` (`keyno`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of syscfg
-- ----------------------------
BEGIN;
INSERT INTO `syscfg` VALUES (100, 'undoMax', NULL, '最大撤销步数', '30', '<=0:不限制,>0:设置', NULL);
INSERT INTO `syscfg` VALUES (101, 'DocTypes', NULL, '文档格式', 'TXT,DOC,DOCX,PPT,PPTX,XLS,XLSX,PDF', NULL, NULL);
INSERT INTO `syscfg` VALUES (102, 'ImgTypes', NULL, '图片格式', 'PNG,JPG,JPEG,BMP,TIF,GIF', NULL, NULL);
INSERT INTO `syscfg` VALUES (103, 'VideoTypes', NULL, '视频格式', '3GP,AVI,ASF,ASX,FLV,MOV,MPG,MP4,OGG,WEBM,WMV', NULL, NULL);
INSERT INTO `syscfg` VALUES (104, 'AudioTypes', NULL, '视频格式', 'MP3,WAV', NULL, NULL);
INSERT INTO `syscfg` VALUES (105, 'task_poll', NULL, '任务轮询间隔时间', '10', '单位:分钟,默认:30', NULL);
INSERT INTO `syscfg` VALUES (106, 'vacation_begin', NULL, '年假开始日期', '3.1', NULL, NULL);
INSERT INTO `syscfg` VALUES (108, 'assi_ignore', NULL, '忽略办理人的岗位', '董事长', NULL, NULL);
INSERT INTO `syscfg` VALUES (109, 'urlCrypt', NULL, 'URL加密', '0', NULL, NULL);
INSERT INTO `syscfg` VALUES (111, 'work_time', NULL, '工作时间', '09:00-12:00,13:30-18:00', NULL, NULL);
INSERT INTO `syscfg` VALUES (114, 'clockin_range', NULL, '考勤范围', '{\"latitude\":30.442262,\"longitude\":114.402293,\"radius\":200}', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sysuser
-- ----------------------------
DROP TABLE IF EXISTS `sysuser`;
CREATE TABLE `sysuser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` decimal(1,0) NOT NULL,
  `no` varchar(16) NOT NULL,
  `name` varchar(32) NOT NULL,
  `password` varchar(64) NOT NULL,
  `ismanager` decimal(1,0) NOT NULL DEFAULT '0',
  `isreader` decimal(1,0) NOT NULL DEFAULT '0',
  `imei` varchar(64) DEFAULT NULL,
  `tools` varchar(2048) DEFAULT NULL,
  `lastwin` varchar(512) DEFAULT NULL,
  `note` varchar(2048) DEFAULT NULL,
  `vrytime` timestamp NULL DEFAULT NULL,
  `vrycode` varchar(16) DEFAULT NULL,
  `ischeck` tinyint(4) NOT NULL DEFAULT '0',
  `state` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sysuser_no` (`no`),
  UNIQUE KEY `sysuser_typeid` (`type`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sysuser
-- ----------------------------
BEGIN;
INSERT INTO `sysuser` VALUES (1, 1, 'admin', '管理员', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, '866813030027410', NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (31, 1, '1605', '张艺', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (35, 1, '1711', '许茘娜', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (36, 1, '1508', '张清', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (37, 1, '1505', '于国华', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, '2019-09-02 16:47:40', '127604', 0, NULL);
INSERT INTO `sysuser` VALUES (38, 1, '1506', '叶玉强', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (39, 1, '1503', '包金坤', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (40, 1, '1504', '毛飞', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (42, 1, '1512', '何柳', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (44, 1, '1607', '汪瑶', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (49, 1, '1507', '韩宁', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (50, 1, '1717', '姚孟汐', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (52, 1, '1709', '李敏春', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (53, 1, '1601', '刘端强', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (54, 1, '1603', '方晓炜', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (56, 1, '1714', '陈佳豪', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (58, 1, '1705', '郑朝军', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, '866813030027410', NULL, NULL, NULL, '2019-09-04 16:33:37', '400480', 0, NULL);
INSERT INTO `sysuser` VALUES (59, 1, '1509', '孙强林', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (60, 1, '1602', '曾航旗', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (61, 1, '1710', '王卫', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (62, 1, '1510', '张亮', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (63, 1, '1511', '杨云玲', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (64, 1, '1701', '唐永桥', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (65, 1, '1708', '曾龙梅', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (68, 1, '1702', '陶江源', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (69, 1, '1706', '刘慧琴', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (70, 1, '1707', '程丹丹', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (71, 1, '1502', '李才仙', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (73, 1, '1501', '张发勇', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, '2019-05-05 22:07:10', '706733', 0, NULL);
INSERT INTO `sysuser` VALUES (76, 1, '1801', '伍池明', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (77, 1, '1802', '孙美琴', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (80, 1, '1803', '张华', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (81, 1, '1606', '许彦平', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (85, 1, '1806', '马亚东', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (86, 1, '1807', '阚鹏', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (87, 1, '1808', '桂能', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (92, 1, '1812', '余冠', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (93, 1, '1813', '高旭龙', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (95, 1, '1902', '席万鑫', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (96, 1, '1903', '吴赞', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (97, 1, '1904', '罗志远', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (99, 1, '1811', '刘双燕', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, '2019-09-04 16:31:59', '360273', 0, NULL);
INSERT INTO `sysuser` VALUES (101, 1, '1818', '熊琦琦', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (102, 1, '1817', '罗望平', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (103, 1, '1816', '陈玲静', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (104, 1, '1815', '谢程远', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (105, 1, '1814', '王丽', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (106, 1, '1905', '任利民', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
INSERT INTO `sysuser` VALUES (109, 1, '1908', '邵阳', 'JdVa0oOqQAr0ZMdtcTwHrQ==', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user1
-- ----------------------------
DROP TABLE IF EXISTS `user1`;
CREATE TABLE `user1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `glid` decimal(9,0) NOT NULL,
  `creator` decimal(9,0) NOT NULL DEFAULT '0',
  `no` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `nickname` varchar(32) DEFAULT NULL,
  `gender` decimal(1,0) DEFAULT NULL,
  `email` varchar(64) DEFAULT NULL,
  `cell` varchar(16) DEFAULT NULL,
  `telno` varchar(32) DEFAULT NULL,
  `faxno` varchar(32) DEFAULT NULL,
  `address` varchar(128) DEFAULT NULL,
  `zipcode` varchar(8) DEFAULT NULL,
  `fno` varchar(32) DEFAULT NULL,
  `hrno` varchar(32) DEFAULT NULL,
  `jjlxr` varchar(32) DEFAULT NULL,
  `jjlxdh` varchar(32) DEFAULT NULL,
  `memo` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Triggers structure for table user1
-- ----------------------------
DROP TRIGGER IF EXISTS `userAI`;
delimiter ;;
CREATE TRIGGER `userAI` AFTER INSERT ON `user1` FOR EACH ROW BEGIN
    DECLARE _organname CHAR(64);

    SELECT namec INTO _organname FROM organ WHERE id=NEW.glid;

    INSERT INTO sysuser(type,id,no,name,password) VALUES(1,NEW.id,NEW.no,NEW.name,'JdVa0oOqQAr0ZMdtcTwHrQ==');
    INSERT INTO userdep(userid,organid,username,organname,position) VALUES(NEW.id,NEW.glid,NEW.name,_organname,'员工');
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
